Large database backups
I'm currently having a strange issue with cpanel backups where the sql dump of a large database seems to never exceed about 2.2GB, the database is approx 15GB. The entire mysql directory is copied fine, no problems with this part of the backup.
Backups using mysqlhotcopy also work fine.
Is this a common problem?
Last edited by cyc; 07-10-2010 at 06:42 AM.
anyone?
You may need to edit /etc/my.cnf as follows, and restart mysql server.
-------
[mysqldump]
quick
max_allowed_packet = 16M
[mysqlhotcopy]
interactive-timeout
----------
And try to take cpanel backup now
cPremote : cPanel remote rsync backup plugin
cPnginx : The complete cPanel nginx plugin
We do cPanel Server Management
LinkBack URL
About LinkBacks
Reply With Quote