1. 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

Discussion in 'Server Configuration and Hosting' started by dabollicks, Sep 11, 2012.

  1. dabollicks

    dabollicks 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?

  2. karll

    karll 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 ...)

Share This Page