Monday, March 17, 2008

MySQL copying data folder

I was under the impression that you can copy data/ folder from one MySQL server to the other and you'd get the all the of the databases properly transferred over. Not so. It sort of works - you will get all your databases transferred, but chances are that your users will soon enough start noticing how certain things no longer work in applications.

My only advice is that you need to do a "proper" transfer of databases. Either mysqldump each one or get a tool that can do this quicker (Navicat has a wonderful mechanism of transferring data across servers).

Bottom line: forget copying data subfolders for MySQL server migrations. Do it slowly and properly instead.

No comments: