Hi! "Weaver, Walt" wrote in message ... >Do a "show table status" at the mysql prompt. Under "type" you should see >InnoDB.
Yes, and in really problematic situations, where you have lost your .frm files, for example, you can use innodb_table_monitor as explained in the InnoDB online manual. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB >--Walt Weaver > Bozeman, Montana > >-----Original Message----- >From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, January 15, 2002 10:57 AM >To: Mysql List (E-mail) >Subject: RE: innoDB confusion > > >One final question, and I am done. You have helped me >tremendously--thank you. Wow, I really didn't expect the developer of >the software to answer my questions--this is terrific. > >Is there way to verify that the tables I create are in the InnoDB >tablespace? I am assuming that if I set 'default-table-type=innodb' in >my.ini that all tables created by the MySQL client will be created in >the innodb tablespace. However, they also show up in the MySQL data >directory as .frm files. How do I also know that it was created in the >InnoDB tablespace? Aaron --------------------------------------------------------------------- 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
