On 11/9/2011 7:43 PM, networks1 at cox.net wrote:
> ---- "Michael T. Dean"<mtdean at thirdcontact.com> wrote:
>> =============
> On 11/08/2011 08:55 PM, Steve wrote:
>> I am doing a fresh I stall of Mythtv on an updated machine/OS (going from FC12 to FC15). I dumped mythconverg from the old install before I started. Can I just restore this to the new MySQL
> Yes.
>http://www.mythtv.org/wiki/Database_Backup_and_Restore#Full_restore_of_a_specific_backup_file> or
>http://www.mythtv.org/wiki/Database_Backup_and_Restore#Replacing_an_existing_database> (if FC15's package gives you a database)
>>> and be good to go?
> Assuming you haven't changed the system's host name. If you did change
> the host name, either consider changing it back or
>http://www.mythtv.org/wiki/Database_Backup_and_Restore#Change_the_hostname_of_a_MythTV_frontend_or_backend> .
>>> If so, at what point in the install process should I do it?
> anytime after you have the new MythTV installed
>>> If not, can I save any of the tables, especially the table with watched episodes?
> Actually, you really need to do a full restore.
>>> Unfortunately I don't know exactly which version of Mythtv I was using before. It was last updated in April or May. The new one is the latest version.
> See, also http://www.mythtv.org/wiki/Backend_migration .
>> Mike
>> =======================
>> Thanks, that's helpful. Two things. First, I didn't do the backup with mythconverg_backup.pl. Instead just used mysqldump. Can I just restore the tables with mysql, or do these scripts do something besides dump the db and gzip it then reverse the process?
>> Second, I think I got the same hostname on the new machine, but I'm not positive. Is the old hostname recorded in the db somewhere so I can check before I restore it?
>>
mysql -uroot -p mythconverg < /whereeverbackupis/mythconvergbak.sql or
whatever you called your backup.
rick