On Tue, Jan 08, 2002 at 10:04:40AM -0500, Michael D. Stackhouse wrote: > We run MySql on our Freebsd server, and on our Win2K server. > > We have several clients, and would like to store the databases in the > clients' root directory. Is this possible?
Under UNIX, all of the separate databases exist as a unique subdirectory under a directory; see references to DATADIR in the documentation. Any one database's tables exists as separate files within the respective database directory. You can physically relocate a database directory to wherever you want, as long as you maintain a symlink to it from the DATADIR. Bear in mind that the MySQL engine will be running as a specific UID, and that UID will need read/write permission for the database's new home... > > Thanks! > -- Brian 'you Bastard' Reichert <[EMAIL PROTECTED]> 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path --------------------------------------------------------------------- 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