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

[Michael T. Dean]

  On 01/04/2011 09:30 PM, Ross Camm wrote:
> 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 ?

Yep.  It's designed to work with any version of MythTV.  The main 
benefit is that it does things to make it less likely for you to have 
problems when you restore to a DB server on which a distro provided a 
MythTV database, and similar.  But, if you get a good database 
backup--regardless of how you get it--and you restore it properly--based 
on the existing configuration and the backup itself--you'll be good.

You just need a SQL-based backup rather than just a MySQL binary data 
file "backup".

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

Note that the MythTV backup will only back up the MythTV database.

> not sure about the restore method yet ;)

Restore script will work, regardless of how you create it.

Mike