--
如下:
语句
1... create table test(id int) engine=myisam data directory='/tmp' index directory='/tmp/abc';
在目录/tmp /tmp/abc 可以执行成功
[mysql@localhost tmp]$ pwd
/tmp
drwxrwxr-x 2 mysql mysql 4096 Mar 30 14:37 abc
mysql> create table test(id int) engine=myisam data directory='/tmp' index directory='/tmp/abc';
Query OK, 0 rows affected (0.00 sec)
mysql> show create table test \g;
+-------+---------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+------------------------------------------------------------------------