Error 1016 using mysqldump on Windows

Friday 27 July 2007 9:59:18 pm

I set up a laptop (Windows Vista) with the eZ Publish 3.9.2 Windows installer package (Mysql, PHP, Apache, eZ Publish) and used it for a bit of development work. I'm trying to move the site to a different machine using this technique (http://ez.no/ezpublish/documentation/configuration/backup_restore/move_to_new_provider), which has worked fine when I've moved from my Linux server. But on the Windows laptop, I get this error:

c:\eZpublish\mysql\bin>mysqldump --opt granite > dump_file.sql
mysqldump: Got error: 1016: Can't open file: 'ezapprove_items.ibd' (errno: 1) wh
en using LOCK TABLES

The Mysql log shows this:

070727 21:19:36  InnoDB error:
Cannot find table granite/ezapprove_items 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.
070727 21:19:36 [ERROR] MySQL: Can't open file: 'ezapprove_items.ibd' (errno: 1)

A web search shows one possibility is that I need to delete any .frm's which have no data in the InnoDB tables. But I'm not clear which .frm's have no data--nor am I sure this is the answer (won't this compromise my eZ Publish installation?).

Anyone know the correct way to handle this situation? Thanks!

Granite Horizon, Certified Developer of eZ Publish Web Solutions
Provider of the SaaS Solution Granite Horizon In The Cloud | http://granitehorizon.com/cloud
http://granitehorizon.com | +1 916 647 6350 | California USA | @granitegreg
Blog: http://granitehorizon.com/blog