Is it possible to have a single mysql server with multiple data directories? I would like to be able to specify where a database is physically located. I know that I can do this for all databases by setting the 'datadir' environment variable, but I have not seen a way to do this for multiple locations. Any ideas? Thanks! Dave --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php