Home > mysql, Tip > Duplicate (transfer) MySQL database between hosts

Duplicate (transfer) MySQL database between hosts

A simple step:

On the source host, enter the following command:

mysqldump -u root -ppasswd1 dbname | ssh -p rmt_ssh_port rmt_usr@dsthost mysql -u root -ppassword2 dbname

[ Reference ]

Advertisements
Categories: mysql, Tip
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: