Re: 5.5 -> 5.6, am I hosed?
Posted by: Bill Seymour
Date: October 13, 2013 05:17PM

OK, so I've got the server starting and I can browse the databases with PhpMySQL. None of the tables actually exist however. Server.err gives messages like this:

131013 16:17:31 [ERROR] Cannot find or open table websitewp/wp_options from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

BTW, when I ran the installer and tried to upgrade from 5.5 to 5.6 (which is where this all started) it instead gave me a new instance of 5.6 running in parallel with the existing 5.5 install. It was not obvious to me how to use it to actually upgrade an existing database. :-(

Options: ReplyQuote


Subject
Views
Written By
Posted
2141
October 06, 2013 03:06PM
1133
October 07, 2013 07:01AM
1422
October 09, 2013 05:50PM
1147
October 10, 2013 10:43AM
1254
October 10, 2013 12:47PM
1117
October 10, 2013 01:41PM
1101
October 10, 2013 05:12PM
1085
October 10, 2013 10:06PM
Re: 5.5 -> 5.6, am I hosed?
1184
October 13, 2013 05:17PM
1126
October 14, 2013 10:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.