
The phpMyAdmin tool can be used to export and import databases up to a few MB in size, providing a simple way to duplicate a copy of a database using a different name on our servers.
(Remember that we already make daily MySQL backups - you only need to follow the instructions on this page if you truly need to duplicate a database under a different name.)
On this page:
You'll then be prompted to save the database file on your personal computer.
You'll first need to create the new, empty database on our servers using the account control panel. After the new database has been created:
(Hint: If you see a "No database selected" error, it's probably because you forgot to first click on the database name in the left-hand column.)
Our system assigns a unique MySQL username to every database that you create. Unfortunately, phpMyAdmin can only copy the database if a single MySQL username has read and write permissions for both databases, which isn't the case.
If the database is more than a few MB in size, phpMyAdmin may have problems importing the file. In that case, advanced users can bypass phpMyAdmin completely using the command line shell, which is much more reliable.
For example, if you have database called customers that you want to copy to new_customers, you would first create a "database dump" file using:
mysqldump -u customers -p customers > customers.dump
Then you'd login to the control panel and create the new MySQL database and run this command to import the dump file, specifying the login details for the new database:
mysql -u new_customers -p new_customers < customers.dump
If you're not comfortable using the shell, please contact us and we'll be glad to do it for you.