-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Blue Presley wrote:
| okay, so my tables have to be of type InnoDB. Is there a
configuration file
| somewhere where i can specify that all my tables be InnoDB so I don't have
| to keep manually specifying the type?
|
Add "set-variable = default-table-type=InnoDB" to the "[mysqld]"
section in your my.cnf file which will either be in /etc or in the data
directory of your MySQL server installation.
-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
iEYEARECAAYFAj0h5w4ACgkQtvXNTca6JD9WYwCdEyanhqt3K5kJMkQTTn3h1vru
QnAAoJ2rA+8NsDZUWCu2Pbvu2dRocrgy
=qCsF
-----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