MySQL represents each database by means of a database directory located
within the data directory. You can move a database directory to a location
outside the datadirectory and replace it with a symlink.
Moving a database directory is very simple. Just follow these steps. (I
think you said you were using windows, if you are using *nix give me a
shout back, the procedure is different.)
1. Stop the server
2. Move the database directory from the data directory to its new location
3. In the data directory create a file that has a name that is the same as
the database name with an extension of .sym This file should contain the
full pathname to the database directory location.
4. Restart the server ensuring the --skip-symbolic-links option is not used.
Hope this is what you are after. Let me know how much success yoou have
with this on Windows. We use symlinking on Linux to distribute load but I
have never tried it on Windows.
MySQL 5 Certified Database Administrator (CMDBA)
MySQL 5 Certified Developer (CMDEV)
MySQL Certified Associate (CMA)
Telephone +44 (0)1283 537111
Mobile +44 (0)7812 451238
> Benedikt Schackenberg wrote:
>> You can configure it in the my.cnf file: there you can set the data
> 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?
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> This email has been scanned by Netintelligence