Re: Unix binary installations somewhere other than in /usr/local
On 28 Jan, Paul DuBois wrote: On 28 Jan John A. Murdie wrote: I decided that it was probably simpler just to build from source - I'm on a Solaris 2.8 system - and so it proved to be. I was careful to use the recommended configure options. I found that I had to build in the installation directory - `make install' didn't copy the `scripts' sub-directory to the installation directory, for instance, when (in my first attempt) I unpacked the source in one directory (the build directory) and configured for another (the installation directory). For my second and successful build I made the build and installation directories the same. I can't find, however, any documentation of a command to clean the build files (e.g. `configure', `INSTALL-SOURCE' etc.) from the build/installation directory. Is there a `make tidy' or something similar? (`make clean' looks as if it would delete the executables!) make distclean removes the most stuff. Rather too much, I'm afraid - the executables and libraries too. What baffles me is that `make install' doesn't install the `scripts' directory (and probably other necessary files), so it appears that you have to build in the final installation directory (which is not conventional under Unix - I build other programs under /tmp and then do `make install'). When you build in the installation directory you have a lot of build materials left in your installation when it's done. It does no harm, of course, but I'd like to tidy up. (All I can think of is to remove files that are not present in a binary distribution - using a script which calls comm(1) perhaps.) I've scoured the `INSTALL-SOURCE' document, and can find no mention of this nuisance. -- 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
Re: Unix binary installations somewhere other than in /usr/local
On 26 Jan, To: [EMAIL PROTECTED] wrote: I'd like to see an explicit statement that it is possible to install a binary distribution of MySQL in some non-standard place, or not, as the case might be. If it *is* possible, I'd like to see full instructions for doing this. Thanks to the two people who sent me a reply: Jeremy Zawodny and Paul DuBois. Jeremy thought it was possible without a /usr/local/mysql link, and I recall (I subsequently lost his E-mail by accident) Paul thought it was not. (I hope that I've not misrepresented either of you - please correct me if I have!) I decided that it was probably simpler just to build from source - I'm on a Solaris 2.8 system - and so it proved to be. I was careful to use the recommended configure options. I found that I had to build in the installation directory - `make install' didn't copy the `scripts' sub-directory to the installation directory, for instance, when (in my first attempt) I unpacked the source in one directory (the build directory) and configured for another (the installation directory). For my second and successful build I made the build and installation directories the same. I can't find, however, any documentation of a command to clean the build files (e.g. `configure', `INSTALL-SOURCE' etc.) from the build/installation directory. Is there a `make tidy' or something similar? (`make clean' looks as if it would delete the executables!) -- 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
Physical storage of databases
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