MySQL database file location

A

Anonymous

Guest
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
 
by default the database is installed in the data directory specified by
Code: 
datadir=C:/mysql/data
in my.ini file
I think this option is not present in MySQL
If you make tables of InnoDB, then you can specify various files, in which the tables are stored, but then it is generic to InnoDB tables
 
You must log in or register to reply here.
Back
Top