Symptoms
-
Plesk upgrade fails on upgrading MySQL/MariaDB with the error:
Failed to install 'C:ParallelsInstallerparallelsPANEL-WIN_17.5.3dist-msi-Mic
rosoft-2003-i386mysql-admin_mu067.msi': Fatal error during installation. (Error
code 1603)
Got error: 1102: Incorrect database name '#mysql50#example.database' when selecting the database
-
Upgrade of MySQL schema with mysql_upgrade fails with the error:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Failed to ALTER DATABASE `#mysql50#.ssh` UPGRADE DATA DIRECTORY NAME
Error: Incorrect database name '#mysql50#.ssh'
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 1102: Incorrect database name '#mysql50#.ssh' when selecting the database
FATAL ERROR: Error during call to mysql_check for upgrading the tables names. -
There is a folder with dot "
."in/var/lib/mysql/directory.
Cause
Folder with dot (".") in the name in MySQL/MariaDB datadir directory prevents correct execution of mysqlcheck command.
Resolution
Note: MySQL/MariaDB datadir location is defined in my.ini or my.cnf file. By default, it is either /var/lib/mysql (Linux) or "%plesk_dir%DatabasesMySQLdata" or "%plesk_dir%MySQLData" (Windows )
For Linux
-
Connect to the server using SSH
-
List directories having dot "." in the name using the command below:
# ls -la /var/lib/mysql | grep ^d | egrep '.'
-
Move the directory to another location, e.g.:
# mv /var/lib/mysql/.directory /root/
For Windows
- Connect to the server using RDP
- Navigate to the
datadirfolder"%plesk_dir%DatabasesMySQLdata"or"%plesk_dir%MySQLData" - Find the directory having the dot "." in the name and move it to another location.