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]
