3 messages in com.mysql.lists.bugsInnoDB tables must be dropped before ...| From | Sent On | Attachments |
|---|---|---|
| Dan Wright | 06 Nov 2001 15:55 | |
| Heikki Tuuri | 06 Nov 2001 16:19 | |
| Timothy Smith | 06 Nov 2001 18:28 |
| Subject: | InnoDB tables must be dropped before dropping database or recreate will fail |
|---|---|
| From: | Dan Wright (dwri...@exostrategy.com) |
| Date: | 11/06/2001 03:55:08 PM |
| List: | com.mysql.lists.bugs |
From: wrig...@yahoo.com To: mys...@lists.mysql.com Subject: InnoDB tables must be dropped before dropping database or recreate will fail
Description:
mySQL on Linux: InnoDB type table create will fail with error 1005 if a database containing an InnoDB table of the same name is dropped and recreated without dropping the InnoDB table before dropping the database. (On Windows 98 platform, did not get the error.)
How-To-Repeat:
create database blah; use blah; create table mytable (field1 integer) type=innodb; drop database blah; create database blah; use blah; create table mytable (field1 integer) type=innodb;
Fix:
(not a fix but a workaround) insert statement before drop database statement: drop table mytable;
Submitter-Id: Originator: Dan Wright Organization: Exostrategy Partners, LLC
MySQL support: none Synopsis: InnoDB tables must be dropped before dropping database or recreate will fail Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.42 (Source distribution)
Environment:
System: Linux c3po.nodomain.nowhere 2.2.14 #1 SMP Thu Feb 17 11:49:42 MST 2000 i586 unknown Architecture: i586
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O3' CXX='gcc' CXXFLAGS='-O3 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Sep 12 13:46 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x 1 root root 1249760 Jan 23 2001 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 2274372 Jan 23 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jan 23 2001 /usr/lib/libc.so lrwxrwxrwx 1 root root 14 Aug 19 09:04 /usr/lib/libc-client.a -> libc-client4.a -rw-r--r-- 1 root root 2033328 Feb 17 2000 /usr/lib/libc-client4.a Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static --with-innodb