CODEWITHSUNDEEP
mysqlphpmyadmin
DanPB
DanPB

Reputation: 3

How to export an SQL-Database

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

Upvotes: 0

Views: 149

Answers (3)

user329974
user329974

Reputation: 41

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.

Upvotes: 0

ceejayoz
ceejayoz

Reputation: 179994

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

Upvotes: 0

Bozho
Bozho

Reputation: 597046

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

Upvotes: 1

Related Questions