• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Cron job for database backup problem

dabollicks

Active member
#1
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?

Thanks
 

karll

Well-known member
#2
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 ...)