nativeInstallermantis

Modify the MySQL data directory

Before running the commands shown on this page, you should load the Bitnami stack environment by executing the installdir/use_APPNAME script (Linux and MacOS) or by clicking the shortcut in the Start Menu under “Start -> Bitnami APPNAME Stack -> Application console” (Windows). On OS X VMs, the installation directory is /opt/bitnami and OS X VM users can click the “Open Terminal” button to run commands. Learn more about the Bitnami stack environment and about OS X VMs.

The data directory for MySQL is set to installdir/mysql/data by default. You can modify the location of this folder modifying the installdir/mysql/my.cnf file, as shown below:

...
datadir=installdir/mysql/data
...

Also modify the installdir/mysql/scripts/ctl.sh file to reflect the new directory location:

--datadir=installdir/mysql/data

Finally, move the data/ directory to the new location and restart the database.

Last modification September 5, 2018