[Bug 792607] Re: Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

[Clint Byrum]

Hi Dan, thanks for taking the time to file this bug report.

It does in fact look like your innodb table space is hosed in some way,
though there are ways to fix this.

First, backup all your tables:

sudo mysqldump --defaults-extra-file=/etc/mysql/debian.cnf --all-
databases > all_tables.sql

Second, check to see if you have any data in InnoDB tables already:

mysql --defaults-extra-file=/etc/mysql/debian.cnf -e "SELECT * FROM
INFORMATION_SCHEMA.TABLES WHERE ENGINE='InnoDB'"

If you have no tables listed, then you can safely do this:
# Remove innodb database files
sudo service mysql stop
rm /var/lib/mysql/ibdata /var/lib/mysql/ib_logfile*
sudo service mysql start

That should re-create a new innodb table space.

If you do have InnoDB tables already, you may have a lot of data
problems, and thats not something we can solve in a bug report
unfortunately.

It does make me wonder if there's a bug upgrading from 10.10 to 11.04.
Did you upgrade directly from 9.04, or did you go through the steps
(9.04 -> 9.10 -> 10.04 -> 10.10 -> 11.04) ? We do not generally support
upgrades directly from one older stable release to a new one... so this
if thats the case, we probably won't be able to fix that.

Marking Incomplete pending response from Dan.

** Changed in: mysql-5.1 (Ubuntu)
       Status: New => Incomplete

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.1 in Ubuntu.
https://bugs.launchpad.net/bugs/792607

Title:
  Plugin 'InnoDB' registration as a STORAGE ENGINE failed.