How do I migrate a database to Toshost? Print

Moving a MySQL database is done with an export and import.

1. On your old host, open phpMyAdmin, select the database, click Export, and download the .sql file (use Custom and gzip for large databases).
2. In Toshost cPanel, open MySQL Databases and create a new database and user, granting the user all privileges.
3. Open phpMyAdmin on Toshost, select the new database, click Import, and upload your .sql file.
4. Update your application's config (e.g. wp-config.php, .env or config.php) with the new database name, user and password; the host is usually localhost.

For very large databases that exceed the upload limit, import via Terminal/SSH or ask us. Need help? Open a ticket and we'll assist.