Migrating MySQL databases from one server to another

Posted by & filed under Server Admin.

Today I needed to begin migrating databases from my live server to the new dedicated database server. The first step is to identify the tables to be moved.

Login to the server as per normal

Then list out the tables to find the one(s) we need to move:

For this example, we will move the “test” database. The next step is to create the new empty test database on the remote server:

The next step is to use the mysqldump command to extract the contents of the current test database and pipe it to the new server database:

Once this command completes, the database will be on both servers.