[Gllug] Backing-up / Moving a MySQL database

[will]

Steve Nicholson wrote:
> On Mon, 23 Sep 2002 21:01:32 +0100 Xander D Harkness wrote:
> 
> 
>>I have just discovered that a new server is being built in the next >few  days to take this software.
>>
>>As many of the users have entered their data, I was wondering how easy > it is to move the database.  Is it a matter of copying a couple of >files?
> 
> 
> If it is going on a new server specially for this software and MySQL isn't being set up for anything else you can just copy across all the database files.  Restart the server and you are away running, I have done this from Windows version to Linux as well (had to change extensions to uppercase).  Has to be the same version of MySQL to help, I think there was a change in one of the versions that had changes in the data files, not 100% sure on that.

This is the method I have used a few times aswell, just scp'ing the database 
files.  Is it better to use mysqldump, or does it not matter?

Will.


-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug