Importing your database

Importing via the Control Panel

PhpMyAdmin can be used via the control panel to import MySQL databases.

You will need the dump file created by MySQL to use this process.

To import your database, from the control panel:

  1. Click the "MySQL web interface" link
  2. Enter the MySQL username and password

  3. Choose the database from the left hand navigation menu
  4. Under "Run SQL Query..." click the "Choose File" button and locate the dump file on your local machine
  5. Choose "Ok", "Import".

Note: You will need to delete (drop) any tables which are in your existing database that share the same name as those being imported from your dump file.

Importing via the command line

Run the command:

mysql < dump_file.txt

Enter the database password when prompted.