innodb tables key problem ?

2003-09-16 Thread Irwin Boutboul
rop foreign key groupid; ERROR 1005: Can't create table './irwingrid/#sql-7515_3.frm' (errno: 150) it is mysql 4.1. Is this a known issue ? If I convert the tables to MyIsam and then try to drop the key, it works fine. Irwin Boutboul Advanced Internet Technology 150 Kettletown Road, B2-N06 Southbury, CT 06488 Phone: 203-486-5614

mysqldump with innoDB

2003-09-16 Thread Irwin Boutboul
? Or shall I first move every table to myIsam and then do the dump, re-import and finally reconvert tables to innodb ? Thanks, Irwin Boutboul Advanced Internet Technology 150 Kettletown Road, B2-N06 Southbury, CT 06488 Phone: 203-486-5614

RE: SQL query crashes MySQL

2003-09-12 Thread Irwin Boutboul
can I run safely my queries with the JDBC driver ? (or shall I test too:) Thanks, Irwin Boutboul Advanced Internet Technology 150 Kettletown Road, B2-N06 Southbury, CT 06488 Phone: 203-486-5614 "Little, Tim" <[EMAIL PROTECTED]> 09/12/2003 01:58 PM To Irwin Boutboul/W

SQL query crashes MySQL

2003-09-12 Thread Irwin Boutboul
ve the details of my table. Shall I file a bug for this one ? (MySQL 4.1) Irwin Boutboul Advanced Internet Technology 150 Kettletown Road, B2-N06 Southbury, CT 06488 Phone: 203-486-5614

Error while altering a table

2003-09-12 Thread Irwin Boutboul
int(6) default '1', PRIMARY KEY (`groupid`) ) TYPE=InnoDB | ++----+ 1 row in set (0.00 sec) Irwin Boutboul Advanced Internet Technology 150 Kettletown Road, B2-N06 Southbury, CT 06488 Phone: 203-486-5614