How do I import or export a MySQL database? Print

Both are done in phpMyAdmin from cPanel.

Export:

1. Open phpMyAdmin and select your database in the left sidebar.
2. Click the Export tab, choose Quick and format SQL, then click Go to download a .sql file.

Import:

1. Create an empty database in MySQL Databases first.
2. Select it in phpMyAdmin, click Import, choose your .sql file, and click Go.

For files larger than the upload limit, see our large-database guide. If the import errors out, open a ticket with the file attached.