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. It is not possible to create the database during import.
As a security precaution, a DreamHost database can only be created within the panel on the (Panel > ‘Goodies’ > ‘MySQL Databases’) page. View the following article for details on how to create your database:
Importing your database
- If your SQL backup file is under 64 MB in size, it can be imported into your new database via phpMyAdmin.
- 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.
View the following article to import a backed up database through phpMyAdmin:
Importing a backed up database using 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