Hi folks. I am trying figure out a way to use my.cnf files (general or user, preferably the later) to set the datadirs for individual users to their home directories on our nfs network, while leaving the mysql users database in the default location at /user/local/mysql/var. We don't want to have that database replicated, if possible. We are set up to have all of our user's home dirs to be backed up of course, and we don't have enough space for everyone's databases on /user/ local, so this is the way we need to do this. I have read one solution in the archives, http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:47012:jahnneofjdicimgfhhhc but it looks like that would require replication of the mysql user access database. Am I mistaken? Short of linking all the database files, is this possible? It's looking to me like there can only be one datadir per instance of the daemon, and that datadir must include the user database...am I wrong? Help! I am using Ver 8.9 Distrib 3.23.27-beta, for sun-solaris2.6 on sparc. Do I need to upgrade? Any help is much appreciated. Sean O'Brien User Systems Coordinator/ Web Designer Computer Science Department Johns Hopkins University [EMAIL PROTECTED] http://cs.jhu.edu/~seannyob 410-516-6457 +------------------------------------------------+ |The finger pointing at the moon is not the moon.| +------------------------------------------------+ --------------------------------------------------------------------- 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
