Applicable to:
- Plesk for Linux
- Plesk for Windows
Symptoms
-
Plesk upgrade fails on upgrading MySQL with the error:
CONFIG_TEXT: Failed to install 'C:\ParallelsInstaller\parallels\PANEL-WIN_17.5.3\dist-msi-Mic
rosoft-2003-i386\mysql-admin_mu067.msi': Fatal error during installation. (Error
code 1603)
CONFIG_TEXT: 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 datadir
directory prevents correct execution of mysqlcheck
command.
Resolution
Note: MySQL datadir
location is defined in my.ini
or my.cnf
file. By default, it is either /var/lib/mysql
(Linux) or "%plesk_dir%\Databases\MySQL\data\"
or "%plesk_dir%\MySQL\Data\"
(Windows )
-
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/
- Connect to the server using RDP
- Navigate to the
datadir
folder"%plesk_dir%\Databases\MySQL\data\"
or"%plesk_dir%\MySQL\Data\"
- Find the directory having the dot "." in the name and move it to another location.
Comments
0 comments
Please sign in to leave a comment.