MySQL database file location

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jeephp
Forum Newbie
Posts: 16
Joined: Sat Apr 23, 2005 4:42 am

MySQL database file location

Post by jeephp »

Hi all
I have a Windows 2003 Server and have installed MySQL 4.3.13-nt on it.
I want to create 3 databases on it called d_one, d_two and d_three etc.

My problem is that I want to use separate folders for each database. Let’s say,
I want to store the database files for d_one at c:\database1 folder, d_two at d:\database2 folder and database d_three at e:\database3 folder.

Is this possible to achieve this? If yes then can I get some guidance on how to go about this.

Thanks
Paresh
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

for MyISAM tables you may specify DATA DIRECTORY option to CREATE TABLE statement.
Post Reply