Cron job for database backup problem


Active member
Right, I run a daily cron job to back up my database. My problem is this. When I backup my database manually via ssh the database size is over 500mb but the cron job backup is only 100mb.

I've not changed anything, this has started happening only recently

Any ideas?



Well-known member
Which software do you use for the backup? mysqldump? mysqlhotcopy? Something else? Are you using the same kind of compression on both (gzip / bzip2 / other)?

I think if you're using mysqlhotcopy, and you have bin logging enabled, there's a possibility that you're copying the bin log, which I don't think you necessarily need.

(Disclaimer: I don't have a ton of experience with this exactly, just trying to help since nobody else have replied ...)