I did do all the upgrades in sequence over the years.  This is the first
time I've really tried to use the innodb based stuff (mythweb and
mythweather), so it could have gotten messed up anywhere along the way.

Checking my backups:  the timestamp on the files indicates they were
last written when I was running 10.10, but I'm also seeing the same
error messages during that time.

I tried the first couple steps you recommended, but they didn't really
work right.

# mysqldump --defaults-extra-file=/etc/mysql/debian.cnf --all-databases > 
~/all_tables.sql
mysqldump: Got error: 1286: Unknown table engine 'InnoDB' when using LOCK TABLES

It sounds like it's finding InnoDB stuff, but can't read it properly.

# mysql --defaults-extra-file=/etc/mysql/debian.cnf -e "SELECT * FROM 
INFORMATION_SCHEMA.TABLES WHERE ENGINE='InnoDB'"
The select returns nothing because that engine never loaded.  It doesn't 
necessarily mean there isn't anything there.

Removing the ib* files (after backing them up) did allow InnoDB to load.
I also had to remove /var/lib/mysql/mythconverg/weather* to keep it from
complaining about old/bad .frm files.  re-installing the mythweb plugin
did re-created the tables.  mythweb now works for me.

I think this means that the bug is probably somewhere in migration
(possibly in a previous version), but (hopefully) isn't reproducible.

Thank you so much for the hand holding.  You can close this bug as not
reproducible.

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

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

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to