Hi ,
I am trying to fix strange problem thats driving me crazy!..I have a mysql database that my application uses. I use InnoDB tables. Recently I have been seeing intermittent problems with accessing the database..the mysql driver complaining that its trying to access file:
Thu Nov 04 14:47:11 GMT 2004: General error: Can't
> create/write to file
> 'C:\DOCUME~1\User1.100\LOCALS~1\Temp\#sql_300_0.MYI'
The above folder does not exist as the user profile User 1 doesn't exist anymore. What is strange is that I use InnoDB, so I don't know why the database is looking for a MYI file.
In order to try to figure out what was going on, I turned on InnoDB tablespace monitoring, and restarted mysql. Now things are even worse. Mysql console tells me that :
"
041116 15:52:21 InnoDB error:
Cannot find table catalyze3/project 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 how you can resolve the problem."
No I cannot even access my database. Can anybody give me any clue as to what is going on??
Thanks
I am trying to fix strange problem thats driving me crazy!..I have a mysql database that my application uses. I use InnoDB tables. Recently I have been seeing intermittent problems with accessing the database..the mysql driver complaining that its trying to access file:
Thu Nov 04 14:47:11 GMT 2004: General error: Can't
> create/write to file
> 'C:\DOCUME~1\User1.100\LOCALS~1\Temp\#sql_300_0.MYI'
The above folder does not exist as the user profile User 1 doesn't exist anymore. What is strange is that I use InnoDB, so I don't know why the database is looking for a MYI file.
In order to try to figure out what was going on, I turned on InnoDB tablespace monitoring, and restarted mysql. Now things are even worse. Mysql console tells me that :
"
041116 15:52:21 InnoDB error:
Cannot find table catalyze3/project 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 how you can resolve the problem."
No I cannot even access my database. Can anybody give me any clue as to what is going on??
Thanks
