I need to Export or Import a MySQL database

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.
  1. Login to your 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 your 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.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What version of MySQL are you running?

The current version can be viewed in the cPanel on left side.

I can't connect to my database locally or remotely, do I have the correct server, username and password?

Since we run a shared hosting environment, we have to uniquely identify your MySQL Users to your...

How do I create an empty MySQL Database

To create the database, do the following: Log into the cpanel Click the MySQL Databases icon...

How do I create a MySQL backup?

There are three options available to backup your MySQL databases: 1) Use the backup utility in...