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.

MySQL Migrate to another server

Discussion in 'Database Discussions' started by kamranonline, Nov 11, 2012.

  1. kamranonline

    kamranonline Member

    Joined:
    Sep 16, 2012
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Newtowncenter
    cPanel Access Level:
    Root Administrator
    Hi,

    I have a dedicated server with cPanel/WHM and more than 11Gb MYSQL Data stores on it.
    So I want to migrate my MYSQL Data to another server, How could this possible ?

    DATABASES + PRVILAGES

    Also, All my users set localhost into their scripts so how could this possible to use another MYSQL Server without changing the scripts configuration and how could it possible to transfer all databases and privilages to another server ?

    Thank you
     
  2. vincentg

    vincentg Well-Known Member

    Joined:
    May 12, 2004
    Messages:
    140
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    new york
    Setup a remote server but you will have to copy each database one by one.

    Best to do in shell using mysqldump and mysql to export and import

    I will create another topic on Remote mysql server
     
  3. ruzbehraja

    ruzbehraja Well-Known Member

    Joined:
    May 19, 2011
    Messages:
    383
    Likes Received:
    7
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    One option is setting up replication.

    The other option is as below:

    Try this out at your own risk.

    This was for migrating an entire server. I guess the data migration process will remain the same.

    http://forums.cpanel.net/f5/upgrading-migrating-new-cpanel-server-293282.html#post1234792

     
Loading...

Share This Page