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

[Chris Petersen]

> 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  ;-)

If you do it while the server is running, you run the risk of damaging
the tables, but it's not that likely that writes would be happening to
the exact same portions of the database that you're copying, etc (if you
put a read lock on all of the tables, then you won't have any issues
with corrupted data).   But yeah, I do this all the time at work - I get
hourly snapshots of our live database for development purposes, and we
don't shut down the website to make the backups.

To "restore," just shut down mysqld on the new machine, copy the files
into place, and restart it.


-- 
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