How to export an SQL-Database

in phpmyadmin to my local disk? I don't see a field where I c开发者_运维问答an 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

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

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.