Page 1 of 1
Best way to restore database tables
Posted: Wed Jul 11, 2018 1:16 am
by 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?
Re: Best way to restore database tables
Posted: Wed Jul 11, 2018 11:22 am
by pvr4me
Re: Best way to restore database tables
Posted: Wed Jul 11, 2018 5:52 pm
by mythfreak
Perfect. Thanks.
Re: Best way to restore database tables
Posted: Fri Jul 13, 2018 10:23 pm
by 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.
Re: Best way to restore database tables
Posted: Fri Jul 13, 2018 10:24 pm
by mythfreak
Oh .. and the upgrade to 17.10 brought mythtv up to .29 automatically. I then went from 17.10 to 18.04LTS.