Remote MySQL Questions

[Scott Greczkows]

I have just ordered a second server for my setup, this new server will be used exclusively for MySQL.

I have just recently noticed that in WHM there is an option for Remote MySQL in there.

My question is what does it do exactly? I want to make sure I don't screw anything up by using it.

I am guessing it copies all databases to the new server, but other then that what does it do? I have looked in the documentation but havent really found what this remote MySQL really does.

Thanks for your help!

 

[ManojB]

Hello Scott,

First you have to install MySQL and Perl on the new server and then you can setup remote connection through WHM >> SQL Services >> Setup Remote MySQL server. After the remote connection is setup you have to login to the old server backup your databases using the following command :

mysqldump database_name > database_name.sql

copy the backup to the new server :

scp -r database_name.sql [email protected]:~

Import/Restore the database on the 2nd server using the following command :

mysql database_name < database_name.sql