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

[Neale Swinnerton]

How about telling us what the differences are?

Chad wrote:
> Hi!
> 
> 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:
> 
> I made a backup of my mythconverg database locally on my remote mysql
> only machine (meaning I was ssh'd into the machine) using just:
> mysqldump -p mythconverg > mythdb.sql
> 
> Then, I made a second one, about 2 hours later using a script from a
> user posted on here:
> #!/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}
> 
>>From my mythbackend (the host being mysqlserver) and got different
> results.  Nothing had been done, no mythfilldatabase was run, nothing
> was recording in that time difference, however their outputs are
> slightly different; any ideas why?
> 
> If you need more info, or if I should attach (or link to) the 2 files,
> please let me know.
> 
> Thanks!
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>