CODEWITHSUNDEEP
mysqldatabaseexportphpmyadmin
sarahbella
sarahbella

Reputation: 31

Exporting a MySQL database through PHPMyAdmin

I'm hoping to export a database that I only have access to through phpMyAdmin so that I can make a copy of it on my localhost. I've never done this before and the database is fairly large at 200 tables. Does anyone have experience doing this? I'm just unsure if the web interface of phpMyAdmin is a reliable way to export that much data or if I'd be causing some performance issues by attempting to export the data.

Thanks for any advice. Thy phpMyAdmin version is 2.1 if that helps any.

Upvotes: 3

Views: 3363

Answers (2)

siliconpi
siliconpi

Reputation: 8297

In the table, select Export, tick the "Save as file" option, and keep the selection as "Compression: None".

You will be able to download huge data tables like this.

Upvotes: 4

Byron Whitlock
Byron Whitlock

Reputation: 53921

The issue you will come against is the max_execution_time setting.

What i have found is large databases take longer to dump than what is set here (defaults to 30 seconds).

This will cause your export to fail.

Also make sure you are not trying to dump to the browser, I have found that option unreliable. Choose the save to a file option, and download the dump via ftp .

But as Col. Shrapnel said, try it first!

Upvotes: 2

Related Questions