drop table if exists `about:text`; create table `about:text` ( _id int not null auto_increment, `about:text` varchar(255) not null default '', primary key (_id) ); show create table `about:text`; Table Create Table about:text CREATE TABLE `about:text` ( `_id` int(11) NOT NULL auto_increment, `about:text` varchar(255) NOT NULL default '', PRIMARY KEY (`_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table `about:text`; CREATE DATABASE db1; CREATE DATABASE db2; USE db2; INSERT INTO db2.t1 VALUES (1); SELECT * FROM db2.t1; b 1 RESET QUERY CACHE; USE db1; SET SESSION keep_files_on_create = TRUE; CREATE TABLE t1 (a INT) ENGINE MYISAM; ERROR HY000: Can't create/write to file './db1/t1.MYD' (Errcode: 17) CREATE TABLE t3 (a INT) Engine=MyISAM; INSERT INTO t3 VALUES (1),(2),(3); TRUNCATE TABLE t3; SELECT * from t3; a SET SESSION keep_files_on_create = DEFAULT; DROP TABLE db2.t1, db1.t3; DROP DATABASE db1; DROP DATABASE db2; USE test;