The directions do not work exactly right. INSTALL-BINARY for one example... The my.cnf examples do not work exactly right. ( Especially since there is some innodb crap in the data directory already to begin with, notably my-small.cnf says look in ../var, and the size of the innodb tablespace does not match up with the default one ) There is confusion in the scripts where .../var/ is supposed to be the DATA directory vs. by default it starts off with .../data ( I simply modified everything to be the /usr/local/mysql/data directory... in the my.cnf and uncommented the stuff it said to uncomment to get the innodb going ) Oh yeah ! I zapped EVERYTHING in the ../data directory EXCEPT for the subdirectories ../mysql and ../test, then I put my good my.cnf in there. THEN stuff started up right... Applying the instructions to unpack the tar.gz and leaving /usr/local/mysql-some-odd-version and making a symbolic link so you have /usr/local/mysql to that... does not work right. I am on Mandrake 8.1, kernel 2.4.17. The symlink thing, I'm not sure what it was, I ended up unpacking straight into /usr/local/mysql ( via the "mv" command after unpacking ) I put the support-files/mysql.server as /etc/init.d/mysql. I had to edit the HOSTNAME thing in there. I had some leftover garbage from previous MySQL installation(s) that seemed to conflict in the PATH since some crap was /bin, and some was /usr/bin, etc., etc., ( So much for RPM's ) After managing through all that I appear to have a happily functioning InnoDB MySQL on Mandrake 8.1 Kernel 2.4.17. I don't know what if anything anyone would like to do about this, just FYI, stuff's not quite right, not nearly smooth or seamless. HOWEVER, I have to say that was a good 3 hour educational experience that I'm actually NOT sorry I had to go through... ( I think because I feel comfortable sort of knowing what I'm doing ) Now... on to playing with all the neato goodies... INSERT INTO ... SELECT ... FROM ... tee hee !!!!!!!!!! ( I wonder if this is going to work out okay with LVM, XFS, Reiser, type stuff... That's for another day, or week... ) THX -AEF -- "When I took off my space suit helmet, I let out a sigh. At least that's what I told the martians..." - Jack Handy --------------------------------------------------------------------- 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
