Updated 10.3 to 11.4, Mysql error Failed to ALTER DATABASE `#mysql50#.tmp` error: 1102

English Applications
#1

I upgraded a system from 10.3 to 11.4 and I get the following error when trying to run mysql:

Will update MySQL now, if you encounter any problems, please read following file:
/usr/share/doc/packages/mysql-community-server/README.SuSE
Log files inconsistency, please merge following files manually:
/var/lib/mysql/mysqld.log
/var/log/mysqld.log
Running protected MySQL…
Upgrading MySQL…
Looking for ‘mysql’ as: /usr/bin/mysql
Looking for ‘mysqlcheck’ as: /usr/bin/mysqlcheck
Running ‘mysqlcheck’ with connection arguments: ‘–port=3306’ ‘–socket=/var/run/mysql/mysql.sock’ ‘–socket=/var/tmp/mysql-protected.aBddlp/mysql.sock’
Failed to ALTER DATABASE #mysql50#.tmp UPGRADE DATA DIRECTORY NAME
Error: Incorrect database name ‘#mysql50#.tmp’
Running ‘mysqlcheck’ with connection arguments: ‘–port=3306’ ‘–socket=/var/run/mysql/mysql.sock’ ‘–socket=/var/tmp/mysql-protected.aBddlp/mysql.sock’
/usr/bin/mysqlcheck: Got error: 1102: Incorrect database name ‘#mysql50#.tmp’ when selecting the database
FATAL ERROR: Upgrade failed
…failed

How can I correct this? Mysql will not start so I can not run any of the utilities.

#2

Hi, do you check permissions?, mysql creates a tmp folder inside of one of this: /tmp, /var/tmp, /usr/tmp.

in my case, it was created in /var/tmp.

#3

There have been several changes to mysql since 10.3, not least in the default language. Rather than trying to upgrade, you would be better off - assuming you have backups of the databases - to reinstall mysql and then change the default language when you import the backup.