The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql_upgrade "FATAL ERROR: Upgrade failed"

Discussion in 'Database Discussions' started by NickolaiLeschov, Apr 11, 2014.

  1. NickolaiLeschov

    NickolaiLeschov Registered

    Joined:
    Apr 11, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    When I ssh to the server and run mysql_upgrade, it returns:
    Code:
    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:

    Code:
    #1102 - Incorrect database name '#mysql50#.cache'
    What can I do?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. NickolaiLeschov

    NickolaiLeschov Registered

    Joined:
    Apr 11, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    No.
    But there are '/var/lib/mysql/.cache', '/var/lib/mysql/.config' and '/var/lib/mysql/.local'.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page