Hi.
> is "Where does InnoDB data get stored?" .................... > table type since it describes it as "default">" Use: show variables like '%innodb_data%'; show variables like 'storage_engine'; Anders Green <[EMAIL PROTECTED]> 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/ | > +===========================================================+ > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]