MySQL 8 Administrator???s Guide

Setting up multiple data directories

As described above, each of the MySQL instances must have a separate data directory. The user is allowed to define separate directories using the following methods:

• Create a new data directory: In this method we must follow the same procedure which was defined in Chapter 2, Installing and Upgrading MySQL. For Microsoft Windows, when we install MySQL 8 from Zip archives, copy its data directory to the location where you want to set up the new instance. In the case of an MSI package along with the data directory, create a pristine template data directory named data under the installation directory. Once the installation is complete, copy the data directory to set up additional instances.
• Copy an existing ...