MySQL crash on ALTER TABLE command

2002-06-03 Thread Archbold, David W.
Hi all, I have a problem with MySQL under Windows NT/2000 where it crashes every time I issue an ALTER TABLE command while the table is being written to under high load. I've tried several versions of MySQL on a few different machines/OS and still the problem remains. I'm hoping someone might

Deleting foreign keys with Innodb tables

2002-07-17 Thread Archbold, David W.
Hi, I'm having a problem dropping a foreign key constraint from an Innodb table. I am using MySQL 3.23.51 for Win32. Any help would be greatly appreciated I have a simple set up like the one below: CREATE TABLE mastertable ( masterkey INT NOT NULL PRIMARY KEY AUTO_INCREMENT ) TYPE=innodb

RE: backup

2002-07-18 Thread Archbold, David W.
DBI is the Perl module used to communicate with the database. The error message is informing you that you do not have the DBI module installed on your system. This isn't a mysql-specific problem, so you should probably consult with an actual Perl help group. At the risk of going off-topic thou