How to export an SQL-Database

views:

answers:

How to export an SQL-Database

in phpmyadmin to my local disk? I don't see a field where I can specify the destination.

PhpMyAdmin offers many export options. Just click on the database and select "Export" from the menu. There you will be able to save the file (offered for download), or get the export queries in a edit box.

If you want to programatically export a mysql database, use mysqldump

Bozho 2010-04-28 12:56:06

Thank you very much. My problem was that in the german version of phpmyadmin it's called "Senden" (what just means send) and not "Save as file", so I wondered where it would be sent and I wasn't allowed to store Data on the server.

DanPB 2010-04-28 13:49:47

In the Export tab, select "Save as file".

ceejayoz 2010-04-28 12:56:10

Below the Options Panel there is an second panel with an checkbox called "save as file" or "send" or similar. You have to check that checkbox. Then the file will be offered for Download like if you download anything else from the Internet.

2010-04-30 17:53:14