Knowledge Base

Upgrade of MySQL/MariaDB schema with mysql_upgrade fails with the error: Error: Incorrect database name ‘#mysql50#.ssh’

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 datadir folder "%plesk_dir%DatabasesMySQLdata" or "%plesk_dir%MySQLData"
Find the directory having the dot "." in the name and move it to another location.