Copying an account with a large database..

Forcerdj

Well-Known Member
Nov 30, 2009
68
1
58
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
 

talk2prakash

Member
Sep 29, 2013
14
0
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
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.