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; 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. Regards, Heikki http://www.innodb.com/ibman.html >I'm trying out MySQL-Front on a Win2k machine and it is having a problem >opening some of my InnoDb tables. > >I can open any of my InnoDb tables if I explicitly specify the database >name in the Connection window. But if I leave the database name blank I'll >see the database tree in the pane on the left. If I try and select one of >my InnoDb tables from underneath the database node, I'll get an error >window saying "MySQL Error - 1016 Can't open file "mytable.InnoDB'. (errno: >1)". Clicking on the database name says one or more of the InnoDb tables >are 0KB. I know there is data in the tables because I can access them in >MySQL. This is the same table that I was able to open in MySQL-Front when >I specified the database explicitly in the Connection window. > >So why does MySQL-Front sometimes have a problem opening InnoDb tables? TIA > >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
