You know, I am knew to MySQL and I was reading the docs where it talks about my.ini file and couldn't make it heads or tales out of it.
I guess I will read it again and hope it makes sense. Thanks for your help! -----Original Message----- From: Tam, Michael [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 2:40 PM To: 'Otoniel Cantu`'; MySQL MailingList (E-mail) Subject: RE: Changing MyISAM to InnoDB Hi Otoniel, I am running w2k as well. Check if your mysql startup properly. One thing you may want to check is whether you have specify the log_dir and data_dir for Innodb in your my.ini file, and that you've made those dirs in the file system. Hope this help. Cheers, Michael -----Original Message----- From: Otoniel Cantu` [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 2:23 PM To: 'Tam, Michael' Subject: RE: Changing MyISAM to InnoDB Hi Michael, I tried creating the table as you described below and same thing happened. MySQL makes it into a MyISAM table. I also tried to alter the table as per your directions and nothing. Am I missing something? I am running w2k. -----Original Message----- From: Tam, Michael [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 11:47 AM To: 'Otoniel Cantu`'; [EMAIL PROTECTED] Subject: RE: Changing MyISAM to InnoDB Alternatives for creating InnoDB tables: 1) When you start mysql, you can pass a parameter to set default-table-type=InnoDB; Then, when you create tables, InnoDB type table is the default type, or 2) In order to create InnoDB type table, you need to create the table in the following way: CREATE TABLE `my_table` (`field1` TINYINT (3) UNSIGNED DEFAULT '0') TYPE = InnoDB; To change between table types: ALTER TABLE my_table TYPE = target_table_type; Hope this help. Best regards, Michael -----Original Message----- From: Otoniel Cantu` [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 10:18 AM To: [EMAIL PROTECTED] Subject: Changing MyISAM to InnoDB For the life of me I can not figure out why I can not create or change my tables from MyISAM to InnoDB. I create the table with InnoDB and MySQL creates the table as MyISAM. I am using MySQL-max-nt. Any ideas how I can change the tables or even create them as InnoDB for that matter? Thanks in advanced. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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