Knowledgebase

Problem:

I need to Export or Import a MySQL database

Solution:

Note: PhpMyAdmin can only import and export databases up to 50 MB in size. If your database is larger you will need to use SSH instead of phpMyAdmin. Click Here for further instructions.

1. Login to the MostHost cPanel
2. Under the category "Databases", click on phpMyAdmin
3. On the left column, select the database name you wish to import to
4. Along the top of the screen click the "Import" tab
5. Click browse under "File to Import" and locate the .sql file on your computer
6. After you have selected the file, click GO and it will import your database.

To Export a database in phpMyAdmin:

1. Login to the MostHost cPanel
2. Under the category "Databases", click on phpMyAdmin
3. On the left column, select the database name you wish to export to
4. Along the top of the screen click the "Export" tab
5. Click Select All or just the tables you need.
6. Check the box saying Save as file and enter a name.
7. Press Go button at bottom right.