Is there a FAQ for users of mySQL? I can't find one on the web site. The O'Reilly book (``MySQL and mSQL'', by R. J. Yarger, George Reese and Tim King) has proved useful. One question I'd like to know the answer to is whether I have to have all the files which store my various user's databases in the mySQL data directory . I know I can configure with e.g.`--localstatedir = /var/mySQL' to cause them to be created and used in another directory, but what I'd really like is for them to be created and used in a user's directory, with the file owned by the user. This way, they get onto our user archival backup without any extra effort on my part. I've tried copying a database file to a user's directory and placing a symbolic link to it in /var/mySQL, but one user is using a GUI on Windows which issues a SQL DROP command to mySQL which causes mySQL to issue a Unix `rmdir' command on the database file. As you can see from the little simulation below, this won't work if a symbolic link is in the way: ; mkdir realdir ; ln -s realdir symlinkdir ; rmdir symlinkdir rmdir: symlinkdir: Not a directory I'd like a configuration option for mySQL to cause databases to be searched for in (say) the user's $HOME/var/mySQL directory. Does anyone else have any interest? -- John A. Murdie Experimental Officer (Software) Department of Computer Science University of York England --------------------------------------------------------------------- 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
