Results 1 to 4 of 4

Thread: 0-byte Database Backups

  1. #1
    Join Date
    Jul 2011
    Beans
    40

    0-byte Database Backups

    Something is causing 0-byte database backups but I can't seem to identify what is doing it. The empty files are of the form mythconverg-20120922223343.sql. I've run all scripts in /etc/cron.daily and none of them seem to be doing it. I suspect BARE but I haven't been able to prove it.

    Ideas?

  2. #2
    Join Date
    Mar 2007
    Location
    Christchurch, NZ
    Beans
    3,239

    Re: 0-byte Database Backups

    Quote Originally Posted by jamoody View Post
    Something is causing 0-byte database backups but I can't seem to identify what is doing it. The empty files are of the form mythconverg-20120922223343.sql. I've run all scripts in /etc/cron.daily and none of them seem to be doing it. I suspect BARE but I haven't been able to prove it.

    Ideas?
    logs?

  3. #3
    Join Date
    Mar 2008
    Beans
    1,086

    Re: 0-byte Database Backups

    The heart of the backup script is mysqldump, which produces the actual backup file. mysqldump errors out if it finds a crashed table or other significant database problem. So perhaps try running mysqlcheck to see whether a one or more crashed tables are found which need to be repaired.

  4. #4
    Join Date
    Nov 2006
    Location
    Oregon
    Beans
    4,433
    Distro
    Ubuntu Development Release

    Re: 0-byte Database Backups

    BARE just uses the MythTV provided backup script for the DB backup, and places the .sql file in a temp directory before gzipping it. If you are seeing the .sql file outside of /tmp then it isn't BARE.
    *Don't PM me directly for support, open a new thread
    *Looking for a MythTV quick start guide?

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •