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:
- Click the "MySQL web interface" link
Enter the MySQL username and password
- Choose the database from the left hand navigation menu
- Under "Run SQL Query..." click the "Choose File" button and locate the dump file on your local machine
- 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.