| Home » Categories » Multiple Categories |
How To Migrate a MySQL Database Between Two Servers |
|
Article Number: 185 | Rating: Unrated | Last Updated: Thu, Dec 26, 2013 at 10:21 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 user@example.com:~/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 
Initial Server Setup with Debian 7
Viewed 3677 times since Fri, Dec 27, 2013
How to Setup and Configure an OpenVPN Server on Debian 6
Viewed 2375 times since Thu, Dec 26, 2013
How to Add a Swap File on an Arch Linux Cloud Server
Viewed 2632 times since Fri, Dec 27, 2013
How To Install Opigno on Debian 7 with Git and Drush
Viewed 3816 times since Sat, Jan 4, 2014
How To Use CakePHP to Create a Small Web Application
Viewed 3071 times since Fri, Jan 3, 2014
How To Manage Content Using the Ghost Blogging Platform
Viewed 8828 times since Sun, Dec 29, 2013
How To Perform Basic Queries in MySQL and MariaDB on a Cloud Server
Viewed 2257 times since Thu, Jan 2, 2014
How To Use WP-CLI to Manage your WordPress Site from the Command Line
Viewed 10067 times since Sat, Jan 4, 2014
How To Setup Ruby on Rails with Postgres
Viewed 11565 times since Mon, Dec 30, 2013
Geddy.JS: A No-Brainer MVC Node.js Framework
Viewed 3236 times since Sun, Dec 29, 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