List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 13 2002 5:30pm
Subject:Re: create table w/ data/index directory
View as plain text  
At 11:21 -0600 11/13/02, Yuyi Guo wrote:
>Hi,
>
>I am using Mysql version: 3.23.52 on Red Hat Linux.

The option is DATA DIRECTORY, not DATA_DIRECTORY, but in any case it was
introduced in 4.0.0.  Your version doesn't support it.

>  I tried to create a table as below and got error. Could some one 
>point me what I did wrong? Or the DATA DIRECTORY defination does not 
>really exist?
>Thanks, Yuyi Guo
>
>mysql>  create table testtable2 (col1 varchar(10) NOT NULL, col2 
>varchar(10), primary key (col1), index idx1 (col2)) 
>DATA_DIRECTORY="/tmp";
>ERROR 1064: You have an error in your SQL syntax near 
>'DATA_DIRECTORY="/tmp"' at line 1

Thread
create table w/ data/index directoryYuyi Guo13 Nov
  • Re: create table w/ data/index directoryPaul DuBois13 Nov
RE: create table w/ data/index directoryKelly W [PCS] Black13 Nov