Transfer MySql Server

GongXi · #1 (**permalink**) 02-27-11, 22:44

Hi,

I would like to transfer MYSQL server from one machine to another machine, any faster way so that all user right setting is copy over to new machine also?

I am using MySql version 5 innodb.

it-iss.com · #2 (**permalink**) 02-28-11, 04:07

After copying across the database make sure that you also make a copy of the database "mysql" which contains the users and the privileges.

From the MySQL documentation:

Quote:

Do not forget to copy the mysql database because that is where the grant tables are stored. You might have to run commands as the MySQL root user on the new machine until you have the mysql database in place.

After you import the mysql database on the new machine, execute mysqladmin flush-privileges so that the server reloads the grant table information.

Internet Services

Web Development

Digital Marketing

Consumer Tech