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. Regards John Daisley ---------------------------------------- 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 Email john.dais...@butterflysystems.co.uk > 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? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk > > > ______________________________________________ > This email has been scanned by Netintelligence > http://www.netintelligence.com/email > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
