Results 1 to 3 of 3

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

  1. #1

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

    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. #2

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

    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. #3
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,454

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

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •