[mythtv-users] DB Backup ?

[Tom Dexter]

On Nov 29, 2007 4:51 PM, John Pierce <john.j35 at gmail.com> wrote:
> Hello All!
>
> I am getting ready to upgrade my be/fe to fedora 8, I have a perfectly
> working system including the streamzap usb remote.  My question has to
> do with the
> backup of the database, if I use the following command to backup and
> then the next to restore the db will I end up with duplicate entries
> for the tuner cards
> and sources?
>
> mysqldump -u<myth_user> -p --extended-insert --databases
> <myth_db_name> > mythdatabase.bak
>
> mysql -u<root_user> -p <mythdatabase.bak
>
> The last time I upgraded the system was from opensuse 10.2 to fedora 7
> and I thought I used those commands to do the backup/restore and I
> ended up
> having to delete the sources, tuner setup and start again.  I would
> prefer to just do the backup/restore and have the system working
> again.
>
> I would appreciate any input that might shed light on this.
>
> TIA
>
> --
> John
> Registered Linux User 263680, get counted at
> http://counter.li.org
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

You definitely won't end up with any duplicate rows.  The resulting
SQL drops tables altogether before creating them and inserting the
data, so that backup and restore should get you back to the exact
state you had.

Just an FYI, at least in mysql 5, the --extended-insert isn't
apparently necessary, as the extended insert commands are used by
default.

Tom