Hi, a simple question ... I have MySQL installed on my Mandrake Linux system, via the RPM's MySQL-4.0.11a-5.1mdk MySQL-common-4.0.11a-5.1mdk MySQL-client-4.0.11a-5.1mdk
Can anyone tell me how a) I check if InnoDB is available with this version ? (in the RPM release notes it seems InnoDB was included in ver 3.23.50-1mdk, so I'm guessing that its still included). b) If it is available, what is the default table type from the RPM ? How do I find out (is there a command line, or MySQL command to give me this info) ? c) How do I get it to use it ? [I've added a file /etc/my.cnf with the line default-table-type=InnoDB Do I need to do anything else ?] The background is that I want to have MySQL check foreign key constraints, and hence prevent deletion from some table if another has a foreign key constraint to that record. Currently it allows deletion with no error. TIA -- Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]