[mythtv-users] Backend DB migration--replace or just restore?

Jim Abernathy jfabernathy at gmail.com
Sat Jul 25 15:17:22 UTC 2020


On 7/25/20 11:09 AM, DryHeat122 wrote:
> I am replacing my Ubuntu 16.04 setup with a clean install of Myth on a 
> clean install of Utuntu 20.04.  I have the old mythconverg backed up 
> and am getting ready to restore.  The wiki backend migration page 
> <https://www.mythtv.org/wiki/Backend_migration> says "Depending on how 
> your distribution initialises the database upon installation of the 
> backend, you may need to use the procedure for replacing the database 
> by the backup 
> <https://www.mythtv.org/wiki/Database_Backup_and_Restore#Replacing_an_existing_database>." 
>
>
> The referenced page says: " If you are replacing an existing database 
> with a known-good backup by using a full restore--for example, because 
> your database has been corrupted or a database schema upgrade failed 
> or you're replacing a package-provided database with your "old" 
> database after re-installing your distro--you will need to drop the 
> existing database. "
>
> I don't know how 20.04 initializes the DB.  I am not replacing the DB 
> because of corruption or failed upgrade.  Do I run 
> mythconverg_restore.pl <http://mythconverg_restore.pl> with defaults 
> or include the drop and create arguments?  Also to be clear, I should 
> restore the DB after installing myth but before running setup, right?

The last time I created fresh and wanted to restore from a good backup I 
had just run on the old system, I did the following command:

/usr/share/mythtv/mythconverg_restore.pl --drop_database 
--create_database --filename /full path to 
directory/mythconverg-1214-20080626150513.sql.gz


Jim A


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20200725/7da271a2/attachment.htm>


More information about the mythtv-users mailing list