How do I merge my databases on to a single server?

This article provides information about database merges and the process taken when a database merge is scheduled in the DreamHost panel.

Why is this an issue?

Most often, your database services are always on a single database server. However, it’s possible that you may have databases split across two different database servers. It’s highly recommended to only use a single database server, as this makes troubleshooting any database-related issue much easier as well as making it simpler to access all of your databases from a single set of user and hostnames.

Checking if you have multiple database servers

  1. Navigate to the (Panel > ‘Goodies’ > ‘Mysql Databases’) page.
  2. Scroll down to the bottom. 01 Merge databases.fw.png

Moving your databases

When you click the Move my databases! button, the migration does not begin immediately. Generally, these merges are performed in the middle of the night (PST).

You are also given an opportunity to cancel the process if you choose not to proceed with the migration.

The following status message appears after you click the button:

Moving databases is not an instantaneous process.
Based on the size of your databases, it can take up to several hours to complete.
You will receive an email at (YourEmailAddress) when the move begins and another when it is completed.
During the move: your sites that use moving databases may not work properly.

After choosing to proceed, the following message appears:

Pending Merges.png

What to expect

At or after midnight, an automated script runs and consolidates your databases onto one server. Once the move is successful, a notification is sent to your email address.

If it takes more than a few hours, the script may have had some kind of problem and you should contact support for further assistance:

See also

Did this article answer your questions?

Article last updated .