Hi all i am working on mysql 4.0 on netware OS. in the my.cnf file i removed the skip-symlink option under mysqld program.
then i used the following query: mysql>create table temp ( id int auto increment primary key, name varchar(20) not null) data directory = 'sys:/etc'; the table is created but the files r still stored in the default data directory. how exactly can we specify the data directory for a particular table? is this the way to do it or am i doing something wrong? thanks prasanth --------------------------------------------------------------------- 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