Tuesday, April 7, 2009

How to Migrate your MySQL server from Windows to *nix (Linux, FreeBSD, OpenSolaris, ...etc)

There are many reasons why a serious sys admin / webmaster would like to migrate their MySQL server to a superior operating environment such as GNU/Linux, FreeBSD, OpenBSD, Solaris, or OpenSolaris, ... etc, this is usually wanted either for security, performance, stability, and reliability.

I believe the "how to?" for that is a simple question that still keeps coming back over and over, so the first thing I should say is that your data don't see the OS, so if you just copy the /data folder and paste it in the new *nix data folder it should work just fine.

If you want to do your things the cleaner way, it is always possible to backup your data as sql code and just run it as such in your new *nix server, no big deals.

I hope this helps.

No comments: