[mythtv-users] Moving to Fedora Core & Myth 0.13: Backup and Restore...

Kristo Kriechbaum klk+myth at robotics.caltech.edu
Fri Dec 19 11:41:25 EST 2003


You may want to use the -c switch to mysqldump.  It will add field
names to the insert statements.  I did something like this months ago,
and the "new" db had the fields in a slightly different order than the
"old" db.  Using -c eliminates that problem.

Kristo

On Fri, Dec 19, 2003 at 10:42:28AM +0000, Richie Jarvis wrote:
> 
> Hi All,
> 
> I would appreciate some checkpointing on the procedure outlined below.
> Last night I tried to perform a fedora upgrade to my existing redhat 9
> config, and, it was not that successful unfortuantly - apt-get seems to
> think that it is still Redhat 9, and the Nvidia drivers refuse to
> acknowledge the FC kernel.
> 
> So, over the weekend, I intend to wipe redhat 9, whilst keeping my
> recorded progs, and a database backup, restore those, and then upgrade
> to mythtv 0.13 - I will report with success/failure and lessons learnt
> afterwards.
> 
> My recorded TV is on /var - and as I plan to wipe everything but the
> /var partition, that means /var becomes my Large Dumping Area(tm)
> 
> Goal: 	Keep existing recorded programs, channel info, and data
> 	Upgrade mythtv pc to fedora core 1
>   	Upgrade mythtv from 0.12 to 0.13
> 	Try the PVR250 card again
> 	Try the PVR250 & the WinTV Card together
> 
> Disk Partitions:
> 
> Filesystem           1K-blocks      Used Available Use% Mounted on
> /dev/hda5              9621848   3226460   5906612  36% /
> /dev/hda1               489992     13899    450793   3% /boot
> /dev/hda6            104757264  25040512  79716752  24% /var
> 
> Method:	
> 
> 1. Backup all mysql db's using command 'mysqldump -A > mythtv.sql', and
> place on /var partition.
> 2. Backup /home to /var (the LDA) (/home has my original builds of
> mythtv, plus other utils I have installed)
> 3. Remove the BT8x8 card & put the PVR250 card in
> 4. Install Fedora Core (as per instructions in Jarods excellant doc) -
> taking care to format / and /boot, but not /var - and make sure /var is
> mounted normally
> 5. Restore mysql db's using command 'mysql < mythtv.sql' so that the
> 0.12 version db is present for when I install 0.13
> 6. Follow Jarods doc to use the correct FC1 kernel, and install MythTV
> 0.13 (and hopefully convert the 0.12 db to 0.13)
> 7. Try it out - and whoop with delight as it all works
> 8. Install the WinTV card alongside the PVR250
> 9. Drink beer after a sucessful install
> 
> Can anyone recommend any changes/good ideas that will save me lots of
> hassle during the upgrade process?
> 
> Thanks,
> 
> Richie
> 
> 
> 


More information about the mythtv-users mailing list