[mythtv-users] Mythbuntu - database not backing up

[Mike Holden]

Nick Rout wrote:
> set -e -u
>
> if [ -f /etc/mythtv/mysql.txt ]; then
>   . /etc/mythtv/mysql.txt
> fi
>
> DBNAME="mythconverg"
> BACKUP="/var/backups/$DBNAME.sql.gz"
> DEBIAN="--defaults-extra-file=/etc/mysql/debian.cnf"
> OPTIONS="--all --complete-insert --extended-insert --quick
> --quote-names --lock-tables"
>
> /usr/bin/mysqlcheck $DEBIAN -s $DBNAME
>
> /usr/bin/savelog -c 7 -l -n -q $BACKUP
>
> /usr/bin/mysqldump $DEBIAN $OPTIONS $DBNAME | gzip > $BACKUP
>
> /usr/bin/logger -p daemon.info -i -t${0##*/} "$DBNAME checked and
> backedup."

The best advice at this stage would be to run the mysqldump command
manually, plugging in the values defined in the script, and look at the
output. Post it here if it isn't obvious!
-- 
Mike Holden

http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Cards and Gifts