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.

Thank开发者_如何学Gos for any advice. Thy phpMyAdmin version is 2.1 if that helps any.

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.

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!