When moving your hosting to DreamHost, it may be necessary to migrate your website’s database. This article describes how to transfer a MySQL database to your DreamHost account.
Creating 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 (Panel > ‘Goodies’ > ‘MySQL Databases’) page. It is not possible to create the database during import.
View the following article for details on how to create your database:
Importing your database
Importing with phpMyAdmin
If your SQL backup file is under 64 MB in size, it can be imported into your new database via phpMyAdmin. View the following article to import a backed up database through phpMyAdmin:
Importing using SSH
If it's 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.
When migrating MySQL from one host to another, it's possible to test the new installation before modifying your domain's DNS entries.
To do this, please review the instructions in the following articles:
- Viewing your site with a dreamhosters.com subdomain before changing DNS
- Accessing your database before DNS change