I have a pre-compiled ODBC program that creates tables and expects them to be transaction-safe. I have set up the mysql-max server to support InnoDB tables. However, since the program knows nothing about InnoDB tables, it creates normal tables and fails when it attempts a rollback. I can fix the problem using the ALTER command. I'm wondering if there is a way (using my.cnf perhaps) that I can tell mysqld to always create tables with type = InnoDB?
Bob Kutter TIBCO Software Inc. http://www.tibco.com --------------------------------------------------------------------- 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