MySQL Forums :: General :: CREATE TABLE ignores DATA DIRECTORY option


Advanced Search

CREATE TABLE ignores DATA DIRECTORY option
Posted by: Rudolf van der Heide ()
Date: October 01, 2010 03:36AM

For performance reasons I want to experiment with data and index directory on different disks. But my CREATE TABLE statement gives a connection warning:


Category Timestamp Duration Message Line Position
Connection 10/1/2010 11:29:57 AM 1618: <DATA DIRECTORY> option ignored 0 0

Any idea what the problem is and how to solve it. I run community server 5.1.50 on windows x64 and the table is on MyISAM.

Thanks for your help.

Rudolf van der Heide
Data Warehouse Specialist
still new on MySQL

Options: ReplyQuote


Subject Written By Posted
CREATE TABLE ignores DATA DIRECTORY option Rudolf van der Heide 10/01/2010 03:36AM
Re: CREATE TABLE ignores DATA DIRECTORY option Guelphdad Lake 10/02/2010 08:27AM
Re: CREATE TABLE ignores DATA DIRECTORY option Rudolf van der Heide 10/04/2010 01:54AM
Re: CREATE TABLE ignores DATA DIRECTORY option Rick James 10/04/2010 07:58AM
Re: CREATE TABLE ignores DATA DIRECTORY option Rick James 10/03/2010 12:06PM
Re: CREATE TABLE ignores DATA DIRECTORY option Shawn Taylor 10/04/2010 08:52AM
Re: CREATE TABLE ignores DATA DIRECTORY option Rick James 10/04/2010 09:26AM
Re: CREATE TABLE ignores DATA DIRECTORY option Rudolf van der Heide 10/04/2010 09:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.