How do I export a MySQL database using phpMyAdmin?

Open phpMyAdmin and select the database from where you want to export data and/or structure. Go to the tab with "Export". Select the table(s) you want to save. Select the option you need: Data only or data and structure or structure only:

--> if you only want to update a table on another server, which has a table with the same structure, then you choose data only

--> if you want to create a new table on another server (for instance, if you have a development environment and you now want to put your application in production) then choose structure only

--> if you are moving a complete table, choose data and structure

Select "save as file"

Hit "go"

You can now enter a filename and specify where the file needs to be saved. It's recommended to choose a meaningful filename that includes the date. Like "user_06_05_04.sql"

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

How do I import a MySQL database using phpMyAdmin?

In the cPanel you will find an Icon labeled MySQL Databases. (If you have not created the...

MySQL Database Troubleshooting

Troubleshooting "Cannot connect to the database" errors... Here are a few initial things (common...

How do I backup MySQL databases in cPanel?

MySQL databases can be backed up by doing the following:Go to 'Backup', in cPanel. Underneath...