Hi,
I'm using MySQL 3.23.39-log compiled from sources on SuSE Linux 6.4. When I
create an InnoDB table with the same name as the database, I get the
following error message:
mysql> create database test;
Query OK, 1 row affected (0.01 sec)
mysql> create table test (x int) type=innodb;
ERROR 1005: Can't create table './test/test.frm' (errno: 0)
Creating an InnoDB table with a different name works fine, as does creating
a MyISAM table with the same name:
mysql> create table test2 (x int) type=innodb;
Query OK, 0 rows affected (0.01 sec)
mysql> create table test (x int);
Query OK, 0 rows affected (0.00 sec)
When I try to convert the MyISAM table to InnoDB, the server crashes and the
table is lost:
mysql> alter table test type = innodb;
ERROR 2013: Lost connection to MySQL server during query
I could provide additional information and maybe a stacktrace if necessary,
but I'd prefer not to recompile the server etc. in case this problem is
already known or easy to fix without.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
