Moving a MySQL installation?

[gboyce at badbelly.com (gboyce)]

On Fri, 13 Apr 2007, Ward Vandewege wrote:

> On Fri, Apr 13, 2007 at 06:55:15PM -0400, Don Levey wrote:
>> I'm upgrading a home machine, which in practice involves simply building
>> a new machine and moving things over to the bigger, faster box.  Not
>> being much of a MySQL person, but using it as the back end of a number
>> of things (Gallery2, Amarok, and others), I find myself needing to move
>> the old data to the new machine or recreate it.  I envision three
>> possibilities, in decreasing levels of desirability:
>>
>> 1) Take the data files and move them wholesale to the new machine.  If
>> this is possible, everything comes over at once and when I start sqld
>> everything "just works".
>>
>> If #1 is a possibility, what files should I move over?
>
> That should work. Just /var/lib/mysql/. Make sure that you:
> a) keep a copy of your original /var/lib/mysql/, just in case
> b) mysqld on the old server is stopped before you start copying
> c) mysqld on the new server is stopped before you start copying

There's a good chance of this failing unless both systems have the same 
version of Mysql.  If there are version differences, architecture 
differences, or various other differences this has a good chance of 
failing.

Greg

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.