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.

Copying an account with a large database..

Discussion in 'Data Protection' started by Forcerdj, Feb 24, 2014.

  1. Forcerdj

    Forcerdj Well-Known Member

    Joined:
    Nov 30, 2009
    Messages:
    60
    Likes Received:
    1
    Trophy Points:
    8
    I'm trying to copy an account to my new server, it has quite a large vbulletin database about 3GB i think.

    I used the 'copy multiple accounts' option within WHM.. this account seemed to take much longer than the others, after the transfer it was throwing database errors when i checked it had only copied a small amount of the database.

    The transfer rate seemed to slow quite a bit when was copying it which is why i think it took so long. not sure if it borked half way through.

    Before i try again i'm wondering if there is a better method to use? is the option i used useless with large databases?

    Thanks
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,472
    Likes Received:
    200
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    You might try doing a Full Account Backup and then move it to the new server manually. And then restore it from there via root.
     
  3. talk2prakash

    talk2prakash Member

    Joined:
    Sep 29, 2013
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Try dumping all the database in a single file .sql and rsync this file to your destination and restore the database.

    Dumping:
    # mysqldump --all-database > alldbbackups.sql

    At the destination end

    #mysql < alldbbackups.sql
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,852
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    You can select the option to skip the account databases when copying the account. Then, create a backup of the database on the source server via:

    Code:
    mysqldump database_name > /home/database_name.sql
    Then, manually transfer that .sql file to the destination server and restore it to the account via:

    Code:
    mysql database_name < /path/to/database_name.sql
    Thank you.
     
Loading...

Share This Page