mysql_upgrade "FATAL ERROR: Upgrade failed"

NickolaiLeschov

• April 11, 2014 09:03

When I ssh to the server and run mysql_upgrade, it returns: Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' Failed to ALTER DATABASE `#mysql50#.cache` UPGRADE DATA DIRECTORY NAME Error: Incorrect database name '#mysql50#.cache' Failed to ALTER DATABASE `#mysql50#.config` UPGRADE DATA DIRECTORY NAME Error: Incorrect database name '#mysql50#.config' Failed to ALTER DATABASE `#mysql50#.local` UPGRADE DATA DIRECTORY NAME Error: Incorrect database name '#mysql50#.local' Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' mysqlcheck: Got error: 1102: Incorrect database name '#mysql50#.cache' when selecting the database FATAL ERROR: Upgrade failed
I tried to delete '#mysql50#.cache' - it throws: #1102 - Incorrect database name '#mysql50#.cache'
What can I do?

• 

  cPanelMichael

  • April 11, 2014 18:02

  Hello :) Does /var/lib/mysql/mysql50.cache exist as a directory on your system? Thank you.

  0
• 

  NickolaiLeschov

  • April 11, 2014 23:35

  [quote="cPanelMichael, post: 1619582">Does /var/lib/mysql/mysql50.cache exist as a directory on your system?
  No. But there are '/var/lib/mysql/.cache', '/var/lib/mysql/.config' and '/var/lib/mysql/.local'.

  0
• 

  cPanelMichael

  • April 15, 2014 17:28

  Those are not standard directories. Did you have a custom installation of MySQL at some point? Rather than removing those directories, I suggest moving them to another location and then checking to see if the same error message persists. Thank you.

  0

Please sign in to leave a comment.