Articles in this section

See more

How to change default MySQL directory %plesk_dir%\Databases\MySQL\data to another one?

Avatar
Yaroslav Tarasov
Updated
Follow
Plesk Onyx 17.8 for Windows kb: how-to ABT: Group A Plesk Obsidian for Windows

Applicable to:

  • Plesk 17.8 for Windows
  • Plesk Obsidian for Windows
  • Plesk Onyx 17.8 for Windows

Question

How to change default MySQL folder to another one?

Answer

Note: Custom data directory location for client's MySQL has been supported since Plesk 17.8 MU #41

To change database location follow next steps:

  1. Connect to the server using RDP as Administrator.

  2. Shut down MySQL service through Control Panel > Administrative Tools > Services > right-click MySQL57 > Stop.

    Note: if MysQL 5.6 is used, stop MySQL Server service instead.

  3. Copy "%plesk_dir%"\Databases\MySQL\data to the new location (e.g. D:\MySQL\data).

  4. Edit "datadir" option in the C:\"%plesk_dir%"\Plesk\Databases\MySQL\my.ini file in the following way:

    CONFIG_TEXT: [MySQLD]
    port=3306
    ...
    datadir=D:\\MySQL\\Data
    ...

  5. Give "Full control" permission to the "NT SERVICE\MySQL57" group: right-click the destination folder > Properties > Security.

    Note: if MysQL 5.6 is used, Give "Full control" permission to the "NT SERVICE\MySQL56" group instead.

  6. Start "MySQL57" service Control Panel > Administrative Tools > Services > right-click MySQL57 > Start.

  7. To prevent "Plesk Reconfigurator" to change the path to the new folder location edit the C:\%plesk_dir%\etc\DiskSecurity.xml file in the following way:

    CONFIG_TEXT: <!-- [PRODUCT_ROOT_D]\MySQL\bin -->
    ...
    <Entry AccounType="1" Domain="NT SERVICE" Account="MySQL57" Path="<D:\MySQL\Data>" AceFlags="FilesOnly" AccessMask="ReadAndExecute" EntryFlags="0x04" />
    ...

    Note: D:\MySQL\Data is the path to the new folder location and can be changed to any required one.

  8. To prevent the resetting of datadir value it is required to change the path in the MYSQL_DATA_D registry to the required one:
    8.1. Click the Start button.
    8.2. Type regedit.exe and press the Enter button:

    8.3. In the opened Windows registry navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\PLESK\PSA Config\Config and find the MYSQL_DATA_D string which contains the actual database directory:

    Indexable text here
    8.4. Change this value to the required one:
    screenshot1.PNG

Comments

2 comments

Sort by Date Votes
  • Avatar
    Christian (Edited )

    What are the equal instructions for moving any existing MYSQL DB and create a new default MYSQL database directory on Plesk Onyx/Ubuntu?

    0
    Comment actions Permalink
  • Avatar
    Alisa Kasyanova

    @Christian
    Changing the location for a MySQL server is not officially supported by Plesk since it can cause a lot of different issues with websites and overall Plesk performance.
    As an alternative to moving the MySQL data directory to another location, consider mounting a partition from a new disk to the default MySQL data directory location /var/lib/mysql/.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles