[mythtv-users] seeking upgrade advice 0.20 -> 0.23 backend database

[Ross Camm]

thanks for all the good suggestions

can I rely on the 'up-to-date restore script, newer than the one shipped
with 0.23.' to work with my 0.20 database/install for a backup and a
restore when needed ?

my current backup method is

/usr/bin/mysqldump -h localhost --password=xxx0 -u root --opt
--all-databases &>/root/mysql-backups/mysql-database.dump

not sure about the restore method yet ;)


>   On 01/04/2011 09:06 PM, Ross Camm wrote:
>> I finally have managed to compile and make install .23 under etch in
>> /usr/local
>>
>> I still have 0.20 installed via deb packages. I don't want to remove
>> this
>> as mythtv is a critical household application...sure many of you
>> understand ;)
>>
>> would the safest&  easiest way to test if 0.23 is going to run and
>> migrate
>> the 0.20 database be to:
>>
>> 1. stop mythbackend .20
>> 2. stop mysql
>> 3. cp -a /var/lib/mysql /safeplace
>
> Never rely on a binary "backup" of a MySQL database.  Always create a
> good, "portable" backup:
>
> http://www.mythtv.org/wiki/Database_Backup_and_Restore
>
>> 4. start mysql
>> 5. start mythbackend 0.23  /usr/local/bin/mythbackend
>> 6. see what works and what doesn't
>> 7. if all goes bad, restore /var/lib/mysql with mysql stopped
>
> For the restore:
> http://www.mythtv.org/wiki/Database_Backup_and_Restore#Replacing_an_existing_database
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>