Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Unanswered: Transfer MySql Server


    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.

  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain
    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:

    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.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts