>Description:
Can't drop tables!
>How-To-Repeat:
mysql> create table t (I int(4), S varchar(20));
Query OK, 0 rows affected (0.01 sec)
mysql> drop table t;
ERROR 2000: Unknown table 't'
mysql> Bye
>Fix:
Work around by shutting down mysqld and removing files. Not
good for temporary tables though.
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
Lucent Technologies
>MySQL support: email support
>Synopsis: Can't drop tables
>Severity: serious
>Priority: medium
>Category: mysql
>Class:
>Release: mysql-3.22.20a (Source distribution)
>Server: /usr/bin/mysqladmin Ver 7.8 Distrib 3.22.20a, for pc-linux-gnu on i686
TCX Datakonsult AB, by Monty
Server version 3.22.20a-log
Protocol version 9
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 10 min 20 sec
Threads: 1 Questions: 40 Slow queries: 0 Opens: 30 Flush tables: 1
Open tables: 26
>Environment:
System: Linux neade5 2.2.3 #6 Sat Mar 20 10:00:28 EST 1999 i586 unknown
Architecture: i586
Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake
/usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.7.2.3/specs
gcc version 2.7.2.3
Compilation info: CC='egcs' CFLAGS='-O6 -mpentium
-fomit-frame-pointer' CXX='egcs' CXXFLAGS='-O6 -mpentium
-fomit-frame-pointer -felide-constructors -fno-exceptions
-fno-rtti' LDFLAGS=''
Configure command: ./configure --without-debug --enable-shared
--enable-assembler --with-unix-socket-path=/var/lib/mysql/mysql.sock
--with-mysqld-user=mysql --prefix=/ --exec-prefix=/usr
--libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--localstatedir=/var/lib/mysql --infodir=/usr/info
--includedir=/usr/include --mandir=/usr/man
Perl: This is perl, version 5.004_04 built for i386-linux
