How To Export a phpMyAdmin Database

There are often times where you may need to export a database via the phpMyAdmin interface in cPanel. This can be achieved very easily using a couple simple steps:

1. Login to cPanel and click phpMyAdmin under DATABASES.

blobid0.png

2.  Click on the database you want to export and then click Button at the Top that says Export. Note: If this is a WordPress site you can usually find the database name within your wp-config.php file. 

blobid1.png

blobid2.png

3. Click Go to generate a .sql file of your database. This is all that is needed in most cases.

blobid3.png

 

Though the quick export option is all that is needed in most cases, if you did want to export specific tables you can select Custom for export method and check the boxes next to each table that you want to export. 

blobid4.png

Was this article helpful?
0 out of 0 found this helpful