[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