Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MYSQL Transfer

Discussion in 'Database Discussion' started by ArcServerscom, Sep 6, 2012.

  1. ArcServerscom

    ArcServerscom Registered

    Joined:
    Sep 6, 2012
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,

    I am transferring a cPanel account from one server to another using the SSH method. The problem is that my mysql database is 55GB in size, and takes around 3 - 4 days to restore... I am wondering if there is a quicker and more stable way to do this, as after two attempts it doesn't seem likely that I'll be able to maintain a connection to the server for that long.

    Any suggestions are appreciated
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,409
    Likes Received:
    1,955
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    You can use the transfer tools in Web Host Manager to transfer the account without it's databases by selecting the following option:

    "Skip account databases"

    This will transfer the account without the databases. You can then manually backup the database on the source server using the "mysqldump" utility, transfer it over to the destination server using SCP or SFTP, and then restore it. It's a good idea to use utilities such as "screen" when using the command line to ensure you can leave the SSH session.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. ArcServerscom

    ArcServerscom Registered

    Joined:
    Sep 6, 2012
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,

    This is actually very useful, I don't know why I didn't think about using screen.

    Thanks
     
  4. pwhjenny

    pwhjenny Well-Known Member

    Joined:
    Aug 31, 2012
    Messages:
    138
    Likes Received:
    0
    Trophy Points:
    91
    cPanel Access Level:
    Root Administrator
    After taking backup of database using mysqldump, compress it one more time either using gzip or tar tool so the size will be reduced and time will be saved during transferring the database over to new server.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice