How to fix InnoDB corruption cases for the MySQL/MariaDB databases on Plesk for Windows?
Can not connect to the database server: can't connect to mysql server on example.com (10061)
Unable to restore the Microsoft SQL database: Log file size in backup is greater than the maximum allowed size
MariaDB fails to restart after upgrade from 10.5 or below to 10.6 or above using upgrade tool in Plesk
MariaDB crashes after update on a Plesk server: mariadb.service: main process exited, code=exited, status=218/CAPABILITIES
MariaDB pre-upgrade check failed: The following package manager configuration files contain options that may result in an upgrade failure
MySQL does not start after replacing MariaDB: MySQL has been frozen to prevent damage to your system
Unable to check the Mysql/Mariadb status after upgrade: ERROR! MariaDB is running but PID file could not be found
Plesk provides error on opening database list in Tools & Settings > Database servers: Dependent row(s) 'Domains.id = 783' isn't found for 'data_bases.dom_id = 783'.
Unable to dump database manually or during a backup process on Plesk: Error 2013: Lost connection to server during query when dumping table example at row: 0

See more

How to change default MySQL/MariaDB directory %plesk_dir%\Databases\MySQL\data to another one on Plesk for Windows?

Alexander Tsmokalyuk

Updated August 28, 2024 10:08

Plesk for Windows kb: how-to ABT: Group A

Applicable to:

Plesk for Windows

Question

How to change the default clients' MySQL/MariaDB folder to another one?

Answer

In the Windows Start menu, select Start > Plesk > Plesk Reconfigurator.
Select “Change MySQL Data location”.
Browse to the new desired location of the My SQL data. A new folder can be created, if necessary. It is recommended to keep the “Check destination disk space” checkbox selected.
When the location is selected, click Next, and then click Next once again.

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request