GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Downgrade to Percona 5.5

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Downgrade to Percona 5.5

    Hi All,

    I had to downgrade from Percona 5.6 back to 5.5 as I couldn't get it to work with Cpanel (php wouldn't compile and apache wouldn't start with 5.6 installed). Running CentOS6.4 and Percona installed / upgraded via YUM.

    Percona-Server-test-55-5.5.33-rel31.1.566.rhel6.x86_64
    Percona-Server-devel-55-5.5.33-rel31.1.566.rhel6.x86_64
    Percona-Server-server-55-5.5.33-rel31.1.566.rhel6.x86_64
    Percona-Server-client-55-5.5.33-rel31.1.566.rhel6.x86_64
    Percona-Server-shared-55-5.5.33-rel31.1.566.rhel6.x86_64
    Percona-Server-shared-compat-5.5.33-rel31.1.566.rhel6.x86_64

    Now, after downgrading, I'm getting a few errors relating to tables in the mysql database that were created during the upgrade process.


    131014 5:20:06 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/general_log.frm'
    131014 5:20:06 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/innodb_index_stats.frm'
    131014 5:20:06 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/innodb_table_stats.frm'
    131014 5:20:06 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/procs_priv.frm'
    131014 5:20:06 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/slow_log.frm'

    131014 6:04:40 InnoDB: Warning: table 'mysql/slave_master_info'
    InnoDB: in InnoDB data dictionary has unknown flags 10.
    131014 6:04:40 InnoDB: Warning: table 'mysql/slave_relay_log_info'
    InnoDB: in InnoDB data dictionary has unknown flags 10.
    131014 6:04:40 InnoDB: Warning: table 'mysql/slave_worker_info'
    InnoDB: in InnoDB data dictionary has unknown flags 10.

    I've tried searching, and can't find any information on this problem yet.

    I managed to fix the issue with procs_priv.frm, general_log.frm and slow_log.frm by copying the .frm file over from another installation of 5.5, but I can't seem to so anything with the other errors.

    The only thing I've found relating to these tables is here : http://dba.stackexchange.com/questio...db-index-stats

    Is it possible to drop those tables from the database if they aren't needed in 5.5?

    Thanks,
    Matt

  • #2
    Hi,

    I hope you know that while downgrade to 5.5, we need to check below things.
    https://dev.mysql.com/doc/refman/5.6...wngrading.html

    Have you run mysql_upgrade after downgrade to 5.5? If not that I would suggest to do it and let us know if you still face the same issue.

    Comment

    Working...
    X