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

Expecting new users...
http://forums.linhes.org/viewtopic.php?f=17&t=24643
Page 1 of 2

Author:  Liv2Cod [ Wed Apr 12, 2017 5:18 pm ]
Post subject:  Expecting new users...

Mythbuntu announced end-of-life recently. That leaves one fewer "appliance" MythTv distros in the world.

-- Joe

Author:  Girkers [ Wed Apr 12, 2017 7:22 pm ]
Post subject:  Re: Expecting new users...

Did they say why, as it may be something we have to be aware of to ensure LinHES doesn't follow the same path.

Author:  bgrant3406 [ Wed Apr 12, 2017 7:29 pm ]
Post subject:  Re: Expecting new users...

Lack of developers, they went from 10 to 2 and want to spend time in other pursuits.

Author:  mattbatt [ Fri Apr 14, 2017 9:14 pm ]
Post subject:  Re: Expecting new users...

Services like Sling TV and Playstation Vue have reduced the necessity of having a DVR. I've been watching more YouTube shows than Broadcast lately.

Author:  drhood [ Mon Jun 05, 2017 8:28 am ]
Post subject:  Re: Expecting new users...

Hello,

I am a past mythbuntu user looking to become a LinHES user. At least, I am going to give it a try. If I can migrate our data from mythbuntu LinHES, then it will help our migration tremendously. If I am successful migrating, would it be useful to share my experience? If yes to sharing the experience, how should it be done (LinHES forum, LinHES wiki, or other)?

With kind regards,

Author:  brfransen [ Wed Jun 07, 2017 8:06 am ]
Post subject:  Re: Expecting new users...

Welcome to LinHES!

The high level idea for migration from Mythbuntu would be similar to the LinHES R7 to R8 transition (http://linhes.org/projects/linhes/wiki/ ... _R7X_to_R8). But the specific steps would be different than that wiki entry because you are coming from Mythbuntu. The process I would try would be to use the MythTV backup scripts (https://www.mythtv.org/wiki/Database_Backup_and_Restore) to backup your existing DB. Install a clean LinHES system and then do a partial restore of your old DB.

It would be very helpful if you would document what worked and didn't on the Wiki and put a link to it here in the forums.

Author:  drhood [ Thu Jun 08, 2017 11:49 am ]
Post subject:  Re: Expecting new users...

brfransen wrote:
Welcome to LinHES!

The high level idea for migration from Mythbuntu would be similar to the LinHES R7 to R8 transition (http://linhes.org/projects/linhes/wiki/ ... _R7X_to_R8). But the specific steps would be different than that wiki entry because you are coming from Mythbuntu. The process I would try would be to use the MythTV backup scripts (https://www.mythtv.org/wiki/Database_Backup_and_Restore) to backup your existing DB. Install a clean LinHES system and then do a partial restore of your old DB.

It would be very helpful if you would document what worked and didn't on the Wiki and put a link to it here in the forums.


Thank you for these instructions. I can follow the instructions at the link above on doing the partial restore. I have hit a bump because after uploading the mythbuntu backup file, the file does not show up in the drop down list for restoring.

I renamed the long mythbuntu backup file, which ended in .tar.gz, to similar file name convention (including .tgz) as the other backup files.

I reloaded the webpage but still absent.

I have confirmed that the mythbuntu backup file is uploaded into the default system backup directory (/data/storage/disk0/backup/system_backups)

I made sure the file permissions, owner and group of the mythbuntu backup file is the same as the other backup files.

So far, no luck in partial restore.

Any additional tips will be greatly appreciated.

Author:  brfransen [ Thu Jun 08, 2017 11:56 am ]
Post subject:  Re: Expecting new users...

brfransen wrote:
The high level idea for migration from Mythbuntu would be similar to the LinHES R7 to R8 transition (http://linhes.org/projects/linhes/wiki/ ... _R7X_to_R8). But the specific steps would be different than that wiki entry because you are coming from Mythbuntu.
As I said the specific steps will be different because you are coming from Mythbuntu. The format of the backup file is almost certainly not in format that the LinHES restore process understands. You will need to do the process described in the MythTV wiki for a partial restore. Just don't drop the database as it says, just start with the clean LinHES installed DB.

Author:  drhood [ Thu Jun 08, 2017 3:22 pm ]
Post subject:  Re: Expecting new users...

brfransen wrote:
As I said the specific steps will be different because you are coming from Mythbuntu. The format of the backup file is almost certainly not in format that the LinHES restore process understands. You will need to do the process described in the MythTV wiki for a partial restore. Just don't drop the database as it says, just start with the clean LinHES installed DB.


Thank you for such quick responses. The mythbuntu backup file did eventually appear in the drop down list. The mythbuntu backup file contains data from mythtv 0.28; however, the database schema might still be different from LinHES.

I have attempted the backup twice without success. The message that appears is the following:

Quote:
Partial restore of database
---------------------------------

Saving current database settings for selective import
Stopping mythbackend
Couldn't find file mythconverg to restore
Couldn't find file ncid to restore
Importing previous settings into settings_pre_db
Starting mythbackend

Partial restore complete.
All data for linhes has been restored except:
* storage groups definitions
* service menu settings


I don't know what the two "Couldn't find file..." messages mean. It seems like no recording information was restored because the Watch Recordings page is empty.

Should the two files be in the archive?

Could the issue be that the original archive was in .tar.gz format instead of .tgz (I simply renamed the .tar.gz to .tgz)?

Should I create a new post if attempts to restore should continue?

Is this task too big to pursue for a new LinHES user? If yes, will importing the video recordings into mythvideo be our next best option?

Sorry for all the questions. Just trying to figure out what is most time efficient to get a LinHES running without losing all of the previous recordings.

Again, any tips or advice will be appreciated.

Author:  bgrant3406 [ Thu Jun 08, 2017 8:15 pm ]
Post subject:  Re: Expecting new users...

Not a direct answer, but I migrated from Mythdora when they shut it down, perhaps some of the steps are applicable to your migration:
http://forums.linhes.org/viewtopic.php?f=22&t=24017

Author:  brfransen [ Fri Jun 09, 2017 6:40 am ]
Post subject:  Re: Expecting new users...

brfransen wrote:
I don't know what the two "Couldn't find file..." messages mean. It seems like no recording information was restored because the Watch Recordings page is empty.

This is because the backup you created on Mythbuntu is in a different format than LinHES expects. The archive file is not layed out the same. Stop trying to use the LinHES backup and restore scripts (lh_system_restore or anything in Health and Maintenance website) to restore from the Mythbuntu backup.

You need to create the backup using mythconverg_backup.pl on Mythbuntu. Install a clean LinHES system. On the LinHES system copy in the backup file somewhere and then use mythconverg_restore.pl --partial_restore. The command should be something like:
Code:
/usr/share/mythtv/mythconverg_restore.pl --partial_restore --directory=/data/storage/disk0/backup/system_backups --filename=mythconverg.sql.gz --verbose

Author:  drhood [ Sat Jun 10, 2017 4:49 am ]
Post subject:  Re: Expecting new users...

bgrant3406 wrote:
Not a direct answer, but I migrated from Mythdora when they shut it down, perhaps some of the steps are applicable to your migration:
http://forums.linhes.org/viewtopic.php?f=22&t=24017


Thank you. I have checked out the instructions and I may give it a try. The only risk is that I have to reinstall LinHES. I have family visiting today and will try to get to it over the next day or two.

Author:  drhood [ Sat Jun 10, 2017 4:52 am ]
Post subject:  Re: Expecting new users...

brfransen wrote:
brfransen wrote:
I don't know what the two "Couldn't find file..." messages mean. It seems like no recording information was restored because the Watch Recordings page is empty.

This is because the backup you created on Mythbuntu is in a different format than LinHES expects. The archive file is not layed out the same. Stop trying to use the LinHES backup and restore scripts (lh_system_restore or anything in Health and Maintenance website) to restore from the Mythbuntu backup.

You need to create the backup using mythconverg_backup.pl on Mythbuntu. Install a clean LinHES system. On the LinHES system copy in the backup file somewhere and then use mythconverg_restore.pl --partial_restore. The command should be something like:
Code:
/usr/share/mythtv/mythconverg_restore.pl --partial_restore --directory=/data/storage/disk0/backup/system_backups --filename=mythconverg.sql.gz --verbose


Thank you for informing me not to use the scripts at the Health & Maintenance website and suggesting an alternative. I will give it a try over the next day or two.

Author:  drhood [ Sat Jul 01, 2017 10:47 am ]
Post subject:  Re: Expecting new users...

brfransen wrote:
brfransen wrote:
I don't know what the two "Couldn't find file..." messages mean. It seems like no recording information was restored because the Watch Recordings page is empty.

This is because the backup you created on Mythbuntu is in a different format than LinHES expects. The archive file is not layed out the same. Stop trying to use the LinHES backup and restore scripts (lh_system_restore or anything in Health and Maintenance website) to restore from the Mythbuntu backup.

You need to create the backup using mythconverg_backup.pl on Mythbuntu. Install a clean LinHES system. On the LinHES system copy in the backup file somewhere and then use mythconverg_restore.pl --partial_restore. The command should be something like:
Code:
/usr/share/mythtv/mythconverg_restore.pl --partial_restore --directory=/data/storage/disk0/backup/system_backups --filename=mythconverg.sql.gz --verbose


Thank you brfranson.

Your suggestion did work with a slight modification. Below are the complete steps I used for a successful import of the mythtv backend database for restoring the tv recordings information in LinHES.

Pre-Work
Before attempting the import, the first thing I did was ensure that all of my hard drives that contain tv recordings are mounted in LinHES. LinHES only mounted the physical disk that which LinHES is installed; however, I have three other physical hard drives that contain tv recordings. It was important that I mount these additional drives to the same directories that they were mounted to in mythbuntu. Because I had backed up the /etc/fstab file in mythbuntu, I had the information I needed to recreate the directories and mount the additional storage disks. For instructions on how to manually mount a physical hard drive, see the following links.

Mounting Hard Disks and Partitions Using the Linux Command Line

mount and /etc/fstab

How To Use UUID To Mount Partitions / Volumes Under Ubuntu Linux

Note: I mapped directories to each disk based on its UUID in /etc/fstab of the LinHES system.

After mounting the drives to the same directories, I used the following commands to change permissions of the mounted drives and all directories and files stored on them.

This command displays the owner (mythtv) and group (user) names to use.
Code:
ls -l /data/storage


This command updates the owner name
Code:
chown -R OWNERNAMER /PATHTOMOUNTEDDIRECTORY


This command updates the group name
Code:
chgrp -R USERNAME /PATHTOMOUNTEDDIRECTORY


Help Links for chgrp and chown.

Restoring TV Recording Information
Note: In LinHES, I had no TV recordings (empty).

In mythbuntu, I used the backup scripts to create a backup of the database. Mythbuntu named the file with a .tar.gz extension. I saved the backup file to a cd disk and executed the following commands as the root user.

Copied the backup file to LinHES
Code:
cp /media/cdrom/BACKUPFILENAME.tar.gz /home/mythtv


Extracted the backup file
Code:
tar -xzf /home/mythtv/BACKUPFILENAME.TAR.GZ


Note: The database backup file is located in an extracted folder called tmp

Once extracted, I executed the command suggested by brfranson with a slight modification.

Code:
/usr/share/mythtv/mythconverg_restore.pl --partial_restore --filename=/home/mythtv/tmp/BACKUPFILENAME.sql.gz --verbose


It worked!

Author:  grego892 [ Sat Apr 13, 2019 11:27 am ]
Post subject:  Re: Expecting new users...

When I do:

/usr/share/mythtv/mythconverg_restore.pl --partial_restore --filename=/home/mythtv/tmp/BACKUPFILENAME.sql.gz --verbose

It tells me:

ERROR 1062 (23000) at line 2: Duplicate entry 'PBS-2016-10-10 01:00:00-Presidential Debate' for key 'PRIMARY'

ERROR: Cannot write to mysql, stopped at /usr/share/mythtv/mythconverg_restore.pl line 1728, <BACKUP> line 1975.

Does anyone know why it can't write to mysql ?

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