Hi! Ok, it was probably how Brent had moved .frm files around. MySQL-Front is not to blame.
Regards, Heikki http://www.innodb.com At 02:25 PM 10/24/01 -0500, you wrote: >At 03:25 AM 10/24/2001 , you wrote: >>Ansgar, >> >>what could cause the problem Brent reports in MySQL-Front? >> >>InnoDB returns the error "Can't open file mytable.InnoDB" >>when it cannot find the table in its internal data >>dictionary. Maybe the case of letters in the database name >>is wrong? >> >>Brent, >> >>if you look at the MySQL server error log, something like >>'hostname'.err, what does InnoDB say in it? >> >>You could try the MySQL-4.0.0 with your database. Then you could >>do >> >>mysql> create table innodb_table_monitor (a int) type = innodb; > >I'm running Win2k and (as far as I know) these MySQL v4 binaries aren't out >yet. > >>which makes the MySQL server mysqld (not the client mysql) >>to print the contents of InnoDB internal data dictionary >>to the standard output. >> >>To see it it is best that you start mysqld-max.exe from the >>MS-DOS prompt, not as a service, or not inside a safe_mysqld >>wrapper. Actually, when debugging, it is always best to start >>mysqld from the MS-DOS prompt because then you see what is >>happening. > >I'll make a note of that the next time something goes awry. > >But I did find out the problem to my "Can't open file mytable.InnoDB" >problem. It was operator error.<g> The .frm files were to blame. I think I >may have created the tables with a redirected MySQL data directory. Even >though there was a duplicate set of .frm files in the original directory, >they may not have been in sync with the InnoDb internal settings for the >table. So I dropped the tables and rebuilt the databases involved and it >seems to work fine now. > >Your suggestion in the MySQL.Err file: > >"Cannot find table iSample/event from the internal data dictionary >of InnoDB though the .frm file for the table exists. Maybe you have deleted >and created again an InnoDB database but forgotten to delete the >corresponding .frm files of old InnoDB tables?" > >was a nice touch. That pointed me in the right direction. I guess I should >have looked at that first. Oh well, there's always next time.<g> Thanks for >your help. > >Brent > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
