| Home » Categories » Multiple Categories |
How To Migrate a MySQL Database Between Two Servers |
|
Article Number: 185 | Rating: Unrated | Last Updated: Tue, Sep 23, 2025 at 11:32 PM
|
| 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 DumpBefore 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].sqlAfter the dump is performed, you are ready to transfer the database. Step Two—Copy the DatabaseSCP 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 DatabaseOnce the data has been transferred to the new server, you can import the database into MySQL:mysql -u root -p newdatabase < /path/to/newdatabase.sqlWith that, your transfer via SCP will be complete. |
Attachments
There are no attachments for this article.
|
Related Articles 
How To Install LAMP (Linux, Apache, MySQL, PHP) on Fedora
Viewed 4258 times since Thu, Jan 2, 2014
How To Set Up Apache Virtual Hosts on Debian 7
Viewed 3770 times since Fri, Dec 27, 2013
How To Install Linux, Nginx, MySQL, PHP (LEMP) Stack on Debian 7
Viewed 4343 times since Fri, Dec 27, 2013
How To Manage Packages In Ubuntu and Debian With Apt-Get & Apt-Cache
Viewed 7257 times since Fri, Dec 27, 2013
How To Install And Run A Node.js App On Centos 6.4 64bit
Viewed 10917 times since Sun, Dec 29, 2013
How To Launch Your Site on a New Ubuntu 12.04 Server with LAMP, SFTP, and DNS
Viewed 3147 times since Thu, Dec 26, 2013
How To Use Yaourt to Easily Download Arch Linux Community Packages
Viewed 4642 times since Fri, Dec 27, 2013
How To Install Git on Debian 7
Viewed 3191 times since Fri, Dec 27, 2013
How To Set Up an NFS Mount on Ubuntu 12.04
Viewed 10975 times since Tue, Dec 24, 2013
How To Protect SSH with fail2ban on Debian 7
Viewed 3170 times since Fri, Dec 27, 2013
|
Subscribe to Article
Print Article-
Email Article to Friend
Export to PDF
Export to MS Word
Tweet This Article
Digg It
Stumble Upon
Del.icio.us