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

Chad masterclc at gmail.com
Mon Apr 25 15:16:26 UTC 2005


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!


More information about the mythtv-users mailing list