How to Migrate a Mysql Database with a simple method PDF Print E-mail
User Rating: / 1
PoorBest 
Programming - MySQL
Written by Joby Joseph   
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 comment


Security code
Refresh

Follow us

  • Digg: opensourcetips
  • Facebook: profile.php?id=100001312990842
  • Facebook Page: 136837466337618
  • Twitter: opensourcetips

Blogroll




Visitors Counter

mod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_counter
mod_vvisit_counterToday:138
mod_vvisit_counterYesterday:601
mod_vvisit_counterThis week:3818
mod_vvisit_counterLast week:3365
mod_vvisit_counterThis month:5575
mod_vvisit_counterLast month:7162

Your IP: 38.107.191.117
Now is: 2010-09-11 07:33

Tag Cloud

Facebook Like Button