-----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