[ILUG] mysql upgrading
John P. Looney
valen at tuatha.org
Wed Jul 14 14:29:08 IST 2004
I upgraded a MySQL database from version 3 to version 4, but one database
is having problems, and it's printing errors like:
Cannot find table webdb2/users 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?
Look from section 15.1 of http://www.innodb.com/ibman.html
how you can resolve the problem.
The reason is that on the original - working - server, there are a number
of databases that have tables that are just .frm files - no MYI files. Any
idea why ?
More information about the ILUG