Mailing List Archive: MythTV: Users

Moved Backend/Frontend and Name change, now want a partial restore

Index | Next | Previous | View Threaded

john at jhit

Nov 26, 2009, 4:00 AM

Post #1 of 7 (737 views)
Permalink

Moved Backend/Frontend and Name change, now want a partial restore

As the subject says, i have moved my backend/frontend to a new box, a new distribution *and* a new name

The new box is fully functional, but before I start recording and creating rules, I'd like to get my old recordings out of the old box.

The database versions are the same (I was using 0.22 from rpmfusion, now Mythbuntu 9.10 - 0,22)
i have a backup or three , taken with the new mythconverg_backup.pl
The mysql password under mythbuntu is a pain - the mythtv user password is OK, as its in a text file, but i can't for the life of me find the db root user, so the following :

http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup
Before performing a partial restore, the database must exist and must have tables. After dropping the mythconverg database:
DROP DATABASE IF EXISTS mythconverg;
run the mc.sql script, as described above. Then, start mythtv-setup to create the database schema. Exit mythtv-setup, and then restore the database:
mythconverg_restore.pl --partial_restore
will not work unless I have the mysql root password

Also, as I understand it, this should only get my recordings and rules back - will I need to reset everything again? (run mythsetup or somesuch?)

What are the implications for the restore regarding the name change? The machine has the same name, but the database was on localhost, and now is on its ip address, is this going to mess the restoration?

Any help or guidance appreciated. i have searched the mythbuntu forums, but the older posts suggest that the root mysql user has a blank password, and this is definitely not the case here

cheers

John

douglas.mackay at gmail

Nov 26, 2009, 5:41 AM

Post #2 of 7 (703 views)
Permalink

Re: Moved Backend/Frontend and Name change, now want a partial restore [In reply to]

2009/11/26 John Haywood <john [at] jhit>:
> As the subject says, i have moved my backend/frontend to a new box, a new
> distribution *and* a new name
> The new box is fully functional, but before I start recording and creating
> rules, I'd like to get my old recordings out of the old box.
> The database versions are the same (I was using 0.22 from rpmfusion, now
> Mythbuntu 9.10 - 0,22)
> i have a backup or three , taken with the new mythconverg_backup.pl
> The mysql password under mythbuntu is a pain - the mythtv user password is
> OK, as its in a text file, but i can't for the life of me find the db root
> user, so the following :
> http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup
> Before performing a partial restore, the database must exist and must have
> tables. After dropping the mythconverg database:
>
> DROP DATABASE IF EXISTS mythconverg;
>
> run the mc.sql script, as described above. Then, start mythtv-setup to
> create the database schema. Exit mythtv-setup, and then restore the
> database:
>
> mythconverg_restore.pl --partial_restore
>
> will not work unless I have the mysql root password
> Also, as I understand it, this should only get my recordings and rules back
> - will I need to reset everything again? (run mythsetup or somesuch?)
> What are the implications for the restore regarding the name change? The
> machine has the same name, but the database was on localhost, and now is on
> its ip address, is this going to mess the restoration?
> Any help or guidance appreciated. i have searched the mythbuntu forums, but
> the older posts suggest that the root mysql user has a blank password, and
> this is definitely not the case here

The mysql root password in mythbuntu is set to the password that was
entered for the linux user during set-up. See
http://www.gossamer-threads.com/lists/mythtv/users/392595
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

mtdean at thirdcontact

Nov 26, 2009, 9:43 AM

Post #3 of 7 (695 views)
Permalink

Re: Moved Backend/Frontend and Name change, now want a partial restore [In reply to]

On 11/26/2009 07:00 AM, John Haywood wrote:
> As the subject says, i have moved my backend/frontend to a new box, a new distribution *and* a new name
>
> The new box is fully functional, but before I start recording and creating rules, I'd like to get my old recordings out of the old box.
>
> The database versions are the same (I was using 0.22 from rpmfusion, now Mythbuntu 9.10 - 0,22)
> i have a backup or three , taken with the new mythconverg_backup.pl
> The mysql password under mythbuntu is a pain - the mythtv user password is OK, as its in a text file, but i can't for the life of me find the db root user, so the following :
>
> http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup
> Before performing a partial restore, the database must exist and must have tables. After dropping the mythconverg database:
>
> DROP DATABASE IF EXISTS mythconverg;
>
> run the mc.sql script, as described above. Then, start mythtv-setup to create the database schema. Exit mythtv-setup, and then restore the database:
>
> mythconverg_restore.pl --partial_restore
>
> will not work unless I have the mysql root password
>
> Also, as I understand it, this should only get my recordings and rules back - will I need to reset everything again? (run mythsetup or somesuch?)
>

You will need to reconfigure /everything/ from scratch. Only your
recordings and recording rules will be restored, and you may have to
recreate all your recording rules (depending on rule type and your new
channel configuration and ...).

In truth, there's really no benefit to doing a partial restore. If your
system is working, a partial restore won't help anything. It doesn't do
any significant amount of cleaning--/maybe/ about 8kiB per old host
that's not recreated.

The partial restore is only really recommended if you have database or
schema corruption and need to use it as a last resort.

> What are the implications for the restore regarding the name change? The machine has the same name, but the database was on localhost, and now is on its ip address, is this going to mess the restoration?
>

Only the host name of the MythTV frontend or backend system is
important. You can always just set the database hostname or IP address
appropriately as it's only stored in $HOME/.mythtv/config.xml or one of
the many mysql.txt files scattered around the file system. (All
config.xml and mysql.txt files will need to be fixed, though.)

> Any help or guidance appreciated. i have searched the mythbuntu forums, but the older posts suggest that the root mysql user has a blank password, and this is definitely not the case here

My recommendation would be: Don't waste your time on a partial
restore. It really won't do anything useful for you and you'll actually
lose some information (like the titles used to find new shows and ...).
If everything is working now, enjoy your good database with all its good
data. :)

Mike

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

john at jhit

Nov 26, 2009, 3:45 PM

Post #4 of 7 (676 views)
Permalink

Re: Moved Backend/Frontend and Name change, now want a partial restore [In reply to]

On 27/11/2009, at 4:43 AM, Michael T. Dean wrote:

> You will need to reconfigure /everything/ from scratch. Only your recordings and recording rules will be restored, and you may have to recreate all your recording rules (depending on rule type and your new channel configuration and ...).
>
> In truth, there's really no benefit to doing a partial restore. If your system is working, a partial restore won't help anything. It doesn't do any significant amount of cleaning--/maybe/ about 8kiB per old host that's not recreated.
>
> The partial restore is only really recommended if you have database or schema corruption and need to use it as a last resort.
>
>> What are the implications for the restore regarding the name change? The machine has the same name, but the database was on localhost, and now is on its ip address, is this going to mess the restoration?
>>
>
> Only the host name of the MythTV frontend or backend system is important. You can always just set the database hostname or IP address appropriately as it's only stored in $HOME/.mythtv/config.xml or one of the many mysql.txt files scattered around the file system. (All config.xml and mysql.txt files will need to be fixed, though.)
>
>> Any help or guidance appreciated. i have searched the mythbuntu forums, but the older posts suggest that the root mysql user has a blank password, and this is definitely not the case here
>
> My recommendation would be: Don't waste your time on a partial restore. It really won't do anything useful for you and you'll actually lose some information (like the titles used to find new shows and ...). If everything is working now, enjoy your good database with all its good data. :)
>
> Mike

Thanks Mike,

The actual hostname of the box has not changed, only the 'internal' (inside myth) from 127.0.0.1 to a real address

Unfortunately, the enjoyment of my current working system is somewhat compromised by the fact that all my wife's old recordings, while available on attached storage, are *not* accessible via MythTV, and asking her to watch '1090_20091123170000.mpg' in the hope that it is indeed last Thursday's Oprah is *not* going to cut it

I'm happy to rename the files and move them into videos, if that were an option, but i can't seem to find a scripted approach to that, either. Hmmm - wonder if I can derive a program name from the file name ....

thanks as always

John
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

mtdean at thirdcontact

Nov 26, 2009, 3:55 PM

Post #5 of 7 (669 views)
Permalink

Re: Moved Backend/Frontend and Name change, now want a partial restore [In reply to]

On 11/26/2009 06:45 PM, John Haywood wrote:
> On 27/11/2009, at 4:43 AM, Michael T. Dean wrote:
>
>> You will need to reconfigure /everything/ from scratch. Only your recordings and recording rules will be restored, and you may have to recreate all your recording rules (depending on rule type and your new channel configuration and ...).
>>
>> In truth, there's really no benefit to doing a partial restore. If your system is working, a partial restore won't help anything. It doesn't do any significant amount of cleaning--/maybe/ about 8kiB per old host that's not recreated.
>>
>> The partial restore is only really recommended if you have database or schema corruption and need to use it as a last resort.
>>
>>> What are the implications for the restore regarding the name change? The machine has the same name, but the database was on localhost, and now is on its ip address, is this going to mess the restoration?
>> Only the host name of the MythTV frontend or backend system is important. You can always just set the database hostname or IP address appropriately as it's only stored in $HOME/.mythtv/config.xml or one of the many mysql.txt files scattered around the file system. (All config.xml and mysql.txt files will need to be fixed, though.)
>>
>>> Any help or guidance appreciated. i have searched the mythbuntu forums, but the older posts suggest that the root mysql user has a blank password, and this is definitely not the case here
>>>
>> My recommendation would be: Don't waste your time on a partial restore. It really won't do anything useful for you and you'll actually lose some information (like the titles used to find new shows and ...). If everything is working now, enjoy your good database with all its good data. :)
> Thanks Mike,
>
> The actual hostname of the box has not changed, only the 'internal' (inside myth) from 127.0.0.1 to a real address
>
> Unfortunately, the enjoyment of my current working system is somewhat compromised by the fact that all my wife's old recordings, while available on attached storage, are *not* accessible via MythTV, and asking her to watch '1090_20091123170000.mpg' in the hope that it is indeed last Thursday's Oprah is *not* going to cut it
>
> I'm happy to rename the files and move them into videos, if that were an option, but i can't seem to find a scripted approach to that, either. Hmmm - wonder if I can derive a program name from the file name ....

Why not just upgrade the whole database, then? It sounds like you
started with a new one?

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

john at jhit

Nov 26, 2009, 4:14 PM

Post #6 of 7 (684 views)
Permalink

Re: Moved Backend/Frontend and Name change, now want a partial restore [In reply to]

On 27/11/2009, at 10:55 AM, Michael T. Dean wrote:

> Why not just upgrade the whole database, then? It sounds like you started with a new one?

Yes, I started with a new one. The database was really the only thing working on the previous system, so it was time to move

cheers
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

mtdean at thirdcontact

Nov 26, 2009, 6:37 PM

Post #7 of 7 (669 views)
Permalink

Re: Moved Backend/Frontend and Name change, now want a partial restore [In reply to]

On 11/26/2009 07:14 PM, John Haywood wrote:
> On 27/11/2009, at 10:55 AM, Michael T. Dean wrote:
>
>> Why not just upgrade the whole database, then? It sounds like you started with a new one?
>>
> Yes, I started with a new one. The database was really the only thing working on the previous system, so it was time to move

So if the database was working, why not take a backup of the database,
restore it, then let MythTV upgrade it and use the "old" database on
your new database server with your new MythTV hosts.

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads