From: Martijn Tonies
Date: June 2 2009 9:56am
Subject: Re: AW: creating databases in different folders
List-Archive: http://lists.mysql.com/mysql/217758
Message-Id: <01ac01c9e368$63203990$1401a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

Hi,


> Benedikt Schackenberg wrote:
>> You can configure it in the my.cnf file: there you can set the data
>> directory. 
> Thanks for the quick reply.
> 
> My concern is that setting the data directory puts ALL databases in that
> folder. What I plan to do is to put databases in separate folders.
> 
> Is that possible?

If you don't use InnoDB, then a "database" IS a folder.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com