Greetings, > > Didn't find any fields in table 'blah' > 031208 18:15:16 InnoDB error: > Cannot find table db/blah 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.
I found out what was causing this, for me at least. When I tar-ed the db's to copy to the new slave server, I did not include the file 'ibdata1' in the tarball. I scp-ed it over and bingo! Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]