79468

Copy an Existing Data Directory

With this method, any MySQL accounts or user data present in the data directory are carried over to the new data directory.

1.    Stop the existing MySQL instance using the data directory. This must be a clean shutdown so that

the instance flushes any pending changes to disk.

2.    Copy the data directory to the location where the new data directory should be.

3.    Copy the my.cnf or my. ini option file used by the existing instance. This serves as a basis for

the new instance.

4.    Modify the new option file so that any pathnames referring to the original data directory refer to the

new data directory. Also, modify any other options that must be unique per instance, such as the

TCP/IP port number and the log files. For a list of parameters that must be unique per instance, see

Section 5.6, “Running Multiple MySQL Instances on One Machinę”.

5.    Start the new instance, telling it to use the new option file.