Trying to fix this problem "mySQL error 1016"
I found this at the InnoDB site.....
--------------------------------------------------------------------------------
Another symptom of an out-of-sync data dictionary is that MySQL prints an error that it cannot open a file yourtablename.InnoDB.
ERROR 1016: Can't open file: 'child2.InnoDB'. (errno: 1)
--------------------------------------------------------------------------------
That seems to be my issue. I just cannot seem to get it to go away.
So this is what it said to do: ------------------------------------- You can drop the orphaned table inside InnoDB by creating an InnoDB table with the same name in another database and moving the .frm file to the current database. Then MySQL thinks the table exists, and DROP TABLE will succeed. -------------------------------------
But it won't DROP with PHPMyAdmin.
Is there a manual way to clear this little buggar out of there?
TIA Mike<mickalo>Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
