Search

How to Migrate a Mysql Database with a simple method PDF Print E-mail
User Rating: / 1
PoorBest 
Programming - MySQL
Thursday, 11 March 2010 15:29

 

If you want to migrate your Mysql Server, you want to export data from one MySQL server to another server, and then import the data to a new server,

It is very simple

Log in to First Server and give  the following command:

 

 

$ mysqldump -u root -p database-name >  filename.sql

 Now Copy the file to second server using FTP, SSH or with a USB Pendrive

On the second Server, you can import the data with the following command:

$ mysql -u root -p -D database-name <  filename.sql

Add this page to your favorite Social Bookmarking websites
 
 

Add comment


Security code
Refresh

We have 99 guests online