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

[Scott Pouliot]

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