Overview
This article describes how to migrate a MySQL database to your DreamHost account.
Migrating a database
To migrate a database:
Create a MySQL database in your panel
Before you can import a database, it must first be created in your panel. As a security precaution, a DreamHost database can only be created within the panel on the MySQL Databases page. It is not possible to create the database during import. See this article for details on how to create your database.
Import your database
You can import using phpMyAdmin or SSH.
Importing with phpMyAdmin — If your SQL backup file is under 64 MB in size, it can be imported into your new database using phpMyAdmin.
Importing using SSH — If the backup file is 64 MB or more (or if you encounter a timeout while importing), the only other option is to import it from the command line via SSH.
Test your database
Before you point your DNS records to DreamHost, you should test the new installation to ensure it's configured correctly. See the following articles for further details:
Point your DNS to DreamHost
When everything has been configured at DreamHost, it's time to update your DNS at your current host. You can either point your nameservers (which points ALL of your DNS records) or point specific A records. See this article for further details.