[mythtv-users] DB Backup ?
turbo at talstar.com
Thu Nov 29 22:07:59 UTC 2007
John Pierce 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
> I would appreciate any input that might shed light on this.
If you look at the created mythdatabase.bak file (it's plain ASCII text), you should see that before each table is defined (and
subsequently filled) there's an "if exists, drop table" line for that specific table... so, no, you shouldn't see any duplicated
entries if you proceed as you outlined.
More information about the mythtv-users