Topic: How do I move mysql databases

[Mats Nordahl]

How do I move mysql databases from one server to another server and get mysql to read/access them correctly?
Is there a simple way to backup the mysql databases and then move them to another server?

[David Helmuth]

You might want to check out the MySQL frontend tool called MySQLFront.

http://anse.de/mysqlfront/

Among other things, it will help you get this accomplished.  It is not really a scriptable solution, but I got the impression you just wanted to move it one time.

-Dave

[Mats Nordahl]

Thanks Dave, I have downloaded it and will try it.

[Mats Nordahl]

This is not easy to do. Please tell me how to connect to mysql on the server, it seame that I don't have the rights to connect. Is there something to change in the server config to get the rights to connect. I am trying to move the databases from a SME 4.1.2 to a SME 5.1.2.