LinHES Forums
http://forums.linhes.org/

Restore Database from R8.3 to R8.4
http://forums.linhes.org/viewtopic.php?f=22&t=24362
Page 1 of 1

Author:  thekingofspain [ Mon Jun 06, 2016 11:55 pm ]
Post subject:  Restore Database from R8.3 to R8.4

I need to restore my R8.3 Database to R8.4. The only thing I could find is lh_system_restore_job which did the opposite of what I thought it was going do; attempted to restore everything but the database.

The LH SQL backup that have is in /data/storage/disk0/backup/mythtv_backups/mythconverge-abcd-fulldate.sql.gz

I see myth has a mythconverg_restore.pl script as an optional download, but I am not sure if that will works with the above backup.

Author:  brfransen [ Tue Jun 07, 2016 7:11 am ]
Post subject:  Re: Restore Database from R8.3 to R8.4

lh_system_restore_job only works with system_backups that are stored by default in /data/storage/disk0/backup/system_backups. The system_backups are the backups that are created by lh_system_backup_job which is automated to run daily with myth_mtc. lh_system_restore_job will only restore the DB and /etc/systemconfig and not any other system files.

The files in mythtv_backups are backups done by the myth backup scripts.

Author:  mattbatt [ Tue Jun 07, 2016 6:18 pm ]
Post subject:  Re: Restore Database from R8.3 to R8.4

best bet would be to install a virgin 8.3 restore and then upgrade. IMHO this is best accomplished in a virtual machine on any computer. Then you can backup after the successful upgrade and dump it on the real mythTV computer.

Author:  thekingofspain [ Sat Jun 11, 2016 12:00 am ]
Post subject:  Re: Restore Database from R8.3 to R8.4

Even after moving the files to disk0 the restore kept bypassing the database restore. I think that was due to the extra disk n's that I had for the raid which left myth and system backup out of sync between the folders on disk1.

I was able to restore the database by downloading the mythconverg_restore.ps cript at https://www.mythtv.org/wiki/Database_Backup_and_Restore

Code:
mythconverg_restore.pl --drop_database --create_database --filename mythconverg-1214-20080626150513.sql.gz

Author:  brfransen [ Sat Jun 11, 2016 6:54 am ]
Post subject:  Re: Restore Database from R8.3 to R8.4

thekingofspain wrote:
Even after moving the files to disk0 the restore kept bypassing the database restore. I think that was due to the extra disk n's that I had for the raid which left myth and system backup out of sync between the folders on disk1.
That is because that file is not a system backup but rather a myth backup. Just moving a myth backup to system backup does not make it a format that the lh_system scripts can handle.

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/