[mythtv-users] OT: Mysql DB backups don't produce same results?

Chris Pinkham cpinkham at bc2va.org
Mon Apr 25 23:57:05 UTC 2005


> I don't know how appropriate it is to post/attach 2 files, one fairly
> large, and one slightly large (~20MB, ~1.7MB) so I won't.  But here's
> my question:


> mysqldump -p mythconverg > mythdb.sql
> 
> #!/bin/sh
> dbdump="/home/mythtv/backup/mythtv_backup.`date '+%w'`.sql.bz2"
> /usr/bin/mysqldump -u mythtv -pmythtv -h mysqlserver mythconverg -c |
> bzip2 -c > ${dbdump}

I hate to state the obvious, but isn't the 18.3MB difference due to
the fact that you're compressing the output with the 2nd command?

-- 
Chris



More information about the mythtv-users mailing list