Copying an account with a large database..

Forcerdj

• February 24, 2014 04:14

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

• 

  Infopro

  • February 24, 2014 09:21

  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.

  0
• 

  talk2prakash

  • February 24, 2014 17:29

  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

  0
• 

  cPanelMichael

  • February 24, 2014 18:46

  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: mysqldump database_name > /home/database_name.sql
  Then, manually transfer that .sql file to the destination server and restore it to the account via: mysql database_name < /path/to/database_name.sql
  Thank you.

  0

Please sign in to leave a comment.