Re: source compilatio or install precompiled packages

2006-10-24 Thread Rocco Di Leo
Hi Jose, there are only a few reasons why you should NOT use a pre-compiled package: 1. The version of MySQL you want to use (e.g. Alpha-Version) does not exist for your machine 2. You want to use features not available in the pre-compiled version. On the other hand there are some very good rea

Re: Creating new table from distinct entries

2006-10-24 Thread Visolve DB Team
Hi, You will get a MySQL query syntax error number 1064 when you incorrectly use a reserved words in your query . * and DISTINCT cannot appear together. Check with the SELECT clause column list. Thanks ViSolve DB Team. - Original Message - From: "Alan Milnes" <[EMAIL PROTECTED]> To

MySQL Camp

2006-10-24 Thread Colin Charles
Hi all, Please note that MySQL Camp will be happening soon in San Francisco, and its being hosted at the Google campus. Do pay it a visit if you're nearby http://mysqlcamp.org/ Check out the interesting topics! -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com

MySQL Camp drawing near

2006-10-24 Thread Jay Pipes
Hello all! The first MySQL Camp (un)conference is coming up in just two weeks! It looks like there will be over 50 MySQL developers and community members joining ranks at Google Headquarters in Mountain View, California, to participate in this community-driven event. Session topics have been pro

Re: source compilatio or install precompiled packages

2006-10-24 Thread Christian Hammers
On 2006-10-24 Jose Manuel Peso wrote: > Why is recommended the precompiled package install way (as i read in the > downloads page)? Because a different compiler version or different installed libraries can result in a slightly different binary. If you happen to experience a bug later it's easier

source compilatio or install precompiled packages

2006-10-24 Thread Jose Manuel Peso
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi list, Why is recommended the precompiled package install way (as i read in the downloads page)? Thanks, Jose -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFP

Re: Client being locked out by aborted connections

2006-10-24 Thread Bill Moran
In response to "Dan Buettner" <[EMAIL PROTECTED]>: > Bill, you can up the value of 'max_connect_errors' (default is 10 it > appears) to make this problem appear less frequently while you > troubleshoot. Thanks for the thought, Dan. Before I do that, I'll just add a cron job to do the flush-hosts

Re: Client being locked out by aborted connections

2006-10-24 Thread Dan Buettner
Bill, you can up the value of 'max_connect_errors' (default is 10 it appears) to make this problem appear less frequently while you troubleshoot. See more information at: http://dev.mysql.com/doc/refman/5.0/en/blocked-host.html http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html As

Client being locked out by aborted connections

2006-10-24 Thread Bill Moran
I have a problem with a PHP client that is frequently getting locked out by the following errors: 061020 14:57:25 [Warning] Aborted connection 7 to db: 'dbname' user: 'root' host: `hostname.collaborativefusion.com' (Got an error reading communication packets) About once a day, the PHP applicati

Re: See how far the slave has replicated from master

2006-10-24 Thread Ryan Tracey
Hi Dominik is there a way to see how far the slave has replicated from the master machine? I know I can issue show slave status on slave, but is there any command on the MASTER to see information on what the slave has read already? I don't think that the master has any idea of what the slave(

See how far the slave has replicated from master

2006-10-24 Thread Dominik Klein
Hi is there a way to see how far the slave has replicated from the master machine? I know I can issue show slave status on slave, but is there any command on the MASTER to see information on what the slave has read already? Regards Dominik -- MySQL General Mailing List For list archives: h