If you installed MySQL 4.1.7 on Windows with the new installer, it will automatically use InnoDB tables as the default unless you specify different. (This is different from earlier versions), so the error was probably not in the Query Browser, but in the server settings in this case.
On Wed, 3 Nov 2004, Anders Green wrote: > Sequence of events: > -had an MS Access db > -converted it to MySQL 4.1.7 with a utility > -everything worked > -using MySQL Query Browser 1.0.1, added three tables > -everything worked > -comes time to deploy to another machine for testing, > copy directory of database over to other machine > -any queries involving the three new tables fail: > mysql> select * from admin; > ERROR 1016 (HY000): Can't open file: 'admin.InnoDB' (errno: 1) > > Now, the first thing to do is go looking for files. > What I find shocks and amazes me! There are missing > files! *grin* > > For each of the three new tables, there is a .frm > file, but no .myd or myi file. Okay..... transfer > aborted or something.... I'll go back to the first > development machine and copy them over. > > WAIT A SECOND! They don't exist on the first > development machine either! And yet, queries > on the first development machine are working, > and those files are nowhere to be found on the > entire drive. > > Ok, I was about to add some info about the > table types... and with the query browser > on the first machine, I saw that they were > all InnoDB instead of MyISAM. Changing those > to MyISAM created the files. Copied those > over to the other machine, restarted the > server there, and they work. > > So now my question (which might be "Why does > the query browser not select MyISAM as the > table type since it describes it as "default">", > or might be "why is my junk not working?") > is "Where does InnoDB data get stored?" > > That is, in what file and what location? > Cause now I'm curious. :) > > Cheers, > Anders > +===========================================================+ > |Anders Green Email: [EMAIL PROTECTED] | > | Home: 919.303.0218 | > | Off Road Rally Racing Team: http://LinaRacing.com/ | > +===========================================================+ > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
