These instructions are designed to help you either export or import a MySQL database using phpMyAdmin. We recommend users perform a backup of their existing website prior to proceeding with the steps below.

1. Exporting a MySQL database with phpMyAdmin
2. Importing a MySQL database with phpMyAdmin
3. phpMyAdmin file size limit

If you're having trouble performing the steps outlined in this article, additional assistance is available from our internal development team at a fee. We strongly recommend that you perform a full backup of your website before performing any of the modifications listed in this article.

1. Exporting a MySQL database with phpMyAdmin

1. Log into cPanel - If you are unsure how to login to cPanel please read the following article: How do I log into cPanel?
2. Select 'phpMyAdmin' under the 'Databases' tab.

Export_DB_Step1

3. In the left hand menu locate the database you wish to export, and click on it. Then select the Export option from the menu.

Export_DB_Step2

4. Within the Export menu click on 'Go' and save the MySQL file onto your computer. There are other custom advanced options that will not be covered by this guide, for now leave the export method as 'quick'.

Export_DB_Step3

2. Importing a MySQL database with phpMyAdmin

Importing a MySQL database is very similar to the exporting instructions above. We'll be starting with a empty database.

1. Select the database which corresponds to your site in the left hand menu.

Import_DB_Step1

2. Select the Import option from the menu.

Import_DB_Step2


3. Within the Import menu click on 'Go' and choose the MySQL file you wish to import from your computer.

Import_DB_Step3


3. phpMyAdmin file size limit

phpMyAdmin has a upload file size limit of 50MB. If your database is larger than 50MB please upload the SQL file to your home directory via either FTP or File manager and then submit a support request asking for the SQL file to be imported into your database. Please include the location of your SQL file and which Database to import it into.

  Print