[mythtv-users] Database update

barbex barbex at gmail.com
Wed Sep 8 12:08:14 UTC 2010


On Wed, Sep 8, 2010 at 3:57 AM, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> I highly recommend doing a complete backup:
>
> http://www.mythtv.org/wiki/Database_Backup_and_Restore
> http://www.mythtv.org/wiki/Database_Backup_and_Restore#Database_Backup
>
> then place the backup somewhere safe (maybe even on a spare USB flash drive
> or whatever if you want to be really safe), then do the upgrade, then if you
> need it (i.e. you replaced the operating system when doing the upgrade or
> your have new hardware or whatever), restore the complete backup:
>
> http://www.mythtv.org/wiki/Database_Backup_and_Restore#Full_restore_of_a_specific_backup_file
> http://www.mythtv.org/wiki/Database_Backup_and_Restore#Replacing_an_existing_database
>

Will the script mentioned in the Wiki work across a version change
like 0.21 to current?

If I make a plain mysqldump and add a "DROP TABLE if exists" in front
of all the SQL thingys, wouldn't that be the same and simpler?


More information about the mythtv-users mailing list