[mythtv-users] Migrating from one box to another?

[Scott Pouliot]

I love mySql......LOL  Can't get much easier than that!  I knew if there was
an easier way....someone out here would be able to show me the light.

Thanks fellas!

Scott 

-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Adam Biskobing
Sent: Wednesday, February 25, 2004 4:42 PM
To: 'Discussion about mythtv'
Subject: RE: [mythtv-users] Migrating from one box to another?

No, mysql handles that like a champ.  No need to restart the server, it'll
just pick it up and run with it.

> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org 
> [mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Scott Pouliot
> Sent: Wednesday, February 25, 2004 3:11 PM
> To: 'Discussion about mythtv'
> Subject: RE: [mythtv-users] Migrating from one box to another?
> 
> 
> mySql doesn't require you to do a detach or anything?  I use SQL 
> Server 7.0 or 2000 on Windows daily...and I know it gets pissed if you 
> simply copy the physical files.  You need to run a stored procedure to 
> detach it first.  If mySql won't freak....then this is easily the best 
> method to use  ;-)
> 
> Thanks Chris! 
> 
> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org 
> [mailto:mythtv-users-bounces at mythtv.org] On > Behalf Of Chris Petersen
> Sent: Wednesday, February 25, 2004 2:35 PM
> To: Discussion about mythtv
> Subject: Re: [mythtv-users] Migrating from one box to another?
> 
> > You can also save the database to an SQL file and restore
> on the other
> machine.
> > See http://www.mythtv.org/docs/mythtv-HOWTO-21.html#ss21.5
> > Some settings may need to be changed but you can do that afterwards.
> 
> Or, you could just copy /var/lib/mysql (or just
> /var/lib/mysql/mythconverg) over to the new machine.
> 
> --
> Chris Petersen
> Programmer / Web Designer
> Silicon Mechanics:  http://www.siliconmechanics.com/
> Blade Servers:      
> http://www.siliconmechanics.com/c292/blade-> server.php 1U
> Servers:         
> http://www.siliconmechanics.com/c272/1u-server.php
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-> bin/mailman/listinfo/mythtv-users
> 
>