Hi Jeremey! > > I think so. I just did that recently in my book. Imagine how many > times I got it backwards and ended up second-guessing myself. :-(
Yes I have that confusion all the time, but it is good to have all mysql tools begin with my or mysql. Also because the installation of MySQL does not remove or alter safe_mysqld, on ends up with two scripts startin mysql. This may not be a problem today however if in the future the mysqld_safe script is altered for (saftey/features/some important reason) people may end up using the wrong startup script. I know my servers use the wrong script! My suggestiion would be to check if safe_mysqld exists during the 4.0 install and if it does remove it, then create a link to mysqld_safe named safe_mysqld. This maintains compatibility for anyone who has existing scripts and uses only one! Then in 4.1 perhaps deprecate the safe_mysqld completely, but I don't think it's a big problem to maintain the link if it exists. Thoughts anyone? > > I'm not sure how they're generated (possibly from the manual), but the > INSTALL-SOURCE and INSTALL-BINARY files in 4.x also have references to > safe_mysqld rather than mysqld_safe. I have noticed someone is looking because I see changes have been made to the FreeBSD notes section. I don't know how I could have missed this as I always look at commits posted to the internals list! So, maybe I should use the comments area of document on the web site, hopefully someone looks at that and will include my other suggestions (Specifcally for BSDi and FreeBSD). Seems much easier just to make my comments on the mysql/docs web page! One other thing, I noticed that Multi-table update is mentioned in the 4.0.2 release notes, but the syntax is not yet in the manual and I didn't see the commit! Did I miss the commit? I want to pull this ASAP and test it. Thanks everyone, Ken P.S. to Monty have been trying to recreate the 'row 0' error with mysqldump unsuccesfully. I am not sure what has changed. Current stats: | Questions | 345687 | | Qcache_queries_in_cache | 5007 | | Qcache_inserts | 26136 | | Qcache_hits | 205394 | | Qcache_not_cached | 3670 | | Qcache_free_memory | 54115092 | | Qcache_free_blocks | 1038 | | Qcache_total_blocks | 11830 | Maybe related to the current great cache hit ratio I am experiencing 59%! > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.41-max: up 26 days, processed 588,003,868 queries (252/sec. avg) > --------------------------------------------------------------------- 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