Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Downgrade to Percona 5.5

matt1206matt1206 EntrantInactive User Role Beginner
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.















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/questions/48166/cannot-open-table-mysql-innodb-index-stats

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

Thanks,
Matt

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.