Re: 2 Problems, Shutdown and BDB (data loss)

2001-03-14 Thread goEbusiness.com Mail Lists
/mysql.sock port=3306 myisam-recover=BACKUP,FORCE log-slow-queries=/usr/local/mysql/data/slow.log log=/usr/local/mysql/data/mysqld.log log-bin=/usr/local/mysql/data/binary.log [mysql.server] user=sql basedir=/usr/local/mysql On Tue, 13 Mar 2001, goEbusiness.com Mail Lists wrote: OS: Solaris 7, Sparc

2 Problems, Shutdown and BDB (data loss)

2001-03-13 Thread goEbusiness.com Mail Lists
OS: Solaris 7, Sparc MySQL Version: 3.23.29a Problem: Sometimes when I do a mysqladmin shutdown on the command line mysql restarts itself instead of shutting down. From the CLI: elvis~ mysqladmin -uadmin -pdevsqladmin shutdown Terminated 010313 18:17:40 mysqld

Re: Max number of Joins

2001-02-07 Thread goEbusiness.com Mail Lists
, Rolf Hopkins wrote: Don't know about max number but unlimited, I would have thought. SELECT b1.foo, b2.foo FROM bar as b1, bar as b2 WHERE ... Will get you a table join on itself. - Original Message - From: "goEbusiness.com Mail Lists" [EMAIL PROTECTED] To: [EMAIL

Max number of Joins

2001-02-06 Thread goEbusiness.com Mail Lists
How many times can I join tables together? What about joining a table to itself? I checked the maillist archive/manual but cannot find a definite answer (searched on "max number of joins", "joins")...I'd though it would be in section 7.20 of the manual but it wasn't. Thanks. Bill