[KLUG Members] Moving a MySQL database....

[Joe Budzynski]

Robert G. Brown wrote:
> ...should be fairly easy, you might think.
> 
> I want to move one from a Windows 2000 server to Linux.
> 
> Apparently it is not quite as simple as archiving all the
> files in a database directory on the Windows machine, copying
> it all over to the Linux box, putting it in an approriate 
> directory, diddling the acces permissions, and so on....
> 
> Someone on this list must have done this, probably on a rather
> routine basis; pointers, suggestions (especially useful or
> amusing ones) are hereby requested...
> 
> Apparently, there are numerous tools out there for this; I'd like
> to read of experience with these, and reccomendations would be
> most welcome.
> 
> 					Thanks and Regards,
> 					---> RGB <---
> 
> 
> _______________________________________________
> Members mailing list
> Members at kalamazoolinux.org
> 
> 
> 
> 
I seem to remember moving a MySQL database using a function built into 
the software called "mysqldump"  It doesn't copy the settings for MySQL 
per-se, but will make a text file backup of the database(s). 
Documentation for it may be found at 
http://dev.mysql.com/doc/mysql/en/mysqldump.html

I've never performed a base installation of MySQL.  But, I'd say you can 
do a base install on the new server, perform the "mysqldump" on your old 
server, and then import the file using "mysqlimport" (info found at 
http://dev.mysql.com/doc/mysql/en/mysqlimport.html).  Don't know if this 
works for what your trying to accomplish, but it might be a start.