Home » Categories » Multiple Categories

How To Migrate a MySQL Database Between Two Servers

Transferring a database between virtual private servers can be accomplished using a SCP (Secure Copy), a method of copying files derived from the SSH Shell. Keep in mind, you will need to know the passwords for both virtual servers.

In order to migrate the database, there are two steps:

Step One—Perform a MySQL Dump

Before transferring the database file to the new VPS, we first need to back it up on the original virtual server by using the mysqldump command.
mysqldump -u root -p --opt [database name] > [database name].sql
After the dump is performed, you are ready to transfer the database.

Step Two—Copy the Database

SCP helps you copy the database. If you used the previous command, you exported your database to your home folder.

The SCP command has the following syntax:
scp [database name].sql [username]@[servername]:path/to/database/
A sample transfer might look like this:
scp newdatabase.sql [email protected]:~/
After you connect, the database will be transferred to the new virtual private server.

Step Three—Import the Database

Once the data has been transferred to the new server, you can import the database into MySQL:
 mysql -u root -p newdatabase < /path/to/newdatabase.sql
With that, your transfer via SCP will be complete.
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
An Introduction to Linux Basics
Viewed 1305 times since Fri, Dec 27, 2013
How To Install and Use Memcache on Ubuntu 12.04
Viewed 1450 times since Tue, Dec 24, 2013
How To Manage Packages In Ubuntu and Debian With Apt-Get & Apt-Cache
Viewed 1182 times since Fri, Dec 27, 2013
How to Get Started With mod_pagespeed with Apache on an Ubuntu and Debian Cloud Server
Viewed 1268 times since Thu, Dec 26, 2013
How To Create a SSL Certificate on Apache for Debian 7
Viewed 1167 times since Fri, Dec 27, 2013
How To Perform Basic Queries in MySQL and MariaDB on a Cloud Server
Viewed 911 times since Thu, Jan 2, 2014
How To Use Yaourt to Easily Download Arch Linux Community Packages
Viewed 2030 times since Fri, Dec 27, 2013
How To Set Up Apache Virtual Hosts on Debian 7
Viewed 1505 times since Fri, Dec 27, 2013
How To Install nginx on Ubuntu 12.04 LTS
Viewed 1474 times since Tue, Dec 24, 2013