Copying an account with a large database..

[Forcerdj]

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]

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.

 

[talk2prakash]

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]

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.