Best way to restore database tables

[mythfreak]

I just upgraded myth on a separate HDD. My current database is from v 0.27, obviously the schema is different on v .29. What is the easiest way to do the partial restore ... just export important tables from the old and import to the new? Does someone have this scripted?

[pvr4me]

See:

https://www.mythtv.org/wiki/Database_Backup_and_Restore

Partial restore discussed at 5.2.4

Craig

[mythfreak]

Perfect. Thanks.

[mythfreak]

On a clean install, after installing Mythbuntu (.28 on 16.04)
echo "DBBackupDirectory=/home/mythtv" > ~/.mythtv/backupr and copied the backed up database to that directory.
mythconverg_restore.pl --drop_database --create_database --filename mythconverg-1317-20180711212033.sql.gz
Then I upgraded distros up to 18.04 and myth upgraded the schema automatically. Easy Peasy.

[mythfreak]

Oh .. and the upgrade to 17.10 brought mythtv up to .29 automatically. I then went from 17.10 to 18.04LTS.