The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Remote MySQL Questions

Discussion in 'General Discussion' started by Scott Greczkows, Mar 2, 2008.

  1. Scott Greczkows

    Scott Greczkows Well-Known Member

    Feb 5, 2004
    Likes Received:
    Trophy Points:
    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!
  2. ManojB

    ManojB Well-Known Member

    Mar 25, 2005
    Likes Received:
    Trophy Points:
    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 hostadmin@ipaddress:~

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

    mysql database_name < database_name.sql

Share This Page