-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Robert Kutter wrote:
| 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
No problem. In your my.cnf add the line
set-variable = default-table-type=InnoDB
And then restart your server.
-Mark
- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma
~ __ ___ ___ ____ __
~ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
~ / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
~ <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6-2 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAj0SM0AACgkQtvXNTca6JD98WgCeJefl2qOO6Z/5+jVuSO9/iCMF
WpcAn1kshjSbC51LUyzqysWdzWIJl4OG
=a39+
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
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
