[ILUG] mysql upgrading

[John P. Looney]

 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 ?

john