Re: Re: learning mysql

2009-03-25 Thread Haidong Ji
I second Claudio's recommendation on Paul DuBois "MySQL" 4th edition. I've followed his book and enjoyed it. Depending on your background, especially if you work predominately in Windows, I think you will need to have easy access to a *nix machine, either a physical one or virtual machines, prefer

Re: Re: learning mysql

2009-03-25 Thread claudio . nanni
Hi, I think in your case you should go for a traditional book approach to build a good background. In my opinion finding the right book is a matter of match between the kind of book and your background. My hint is to gather here 4/5 good book titles, go in a book shop take a while to run thr

Re: learning mysql

2009-03-25 Thread Olaf Stein
If you know in theory what you want to do then I recommend the certification study guide http://www.mysql.com/certification/studyguides/ olaf On 3/24/09 9:00 PM, "solarflow99" wrote: > hi, I'm looking for some advice where to learn mysql. Not being a DBA, I > have basic knowledge of database

Re: Installation Problems

2009-03-25 Thread Manish Gupta
Hi Roland, I wanted to know if you face the sae problems that i've faced or u get somethng else. @ Ian I've already done that. I will do what Roland told me to, lets hope i have some luck this time around. On Wed, Mar 25, 2009 at 2:15 AM, Rolando Edwards wrote: > Ever since MySQL 5.0.27, I have

MySQL 6.0.10 Alpha has been released!

2009-03-25 Thread Jonathan Perkin
Dear MySQL users, MySQL 6.0.10-alpha, a new version of the MySQL database system has been released. The main page for MySQL 6.0 release is at http://www.mysql.com/mysql60/ MySQL 6.0 includes two new storage engines: the transactional Falcon engine, and the crash-safe Maria engine. If you are

Re: Select query locks tables in Innodb

2009-03-25 Thread Carl
Just to close this off. Baron was correct in that the core problem was a bug in MySQL (I was using version 5.0.37.) There are some references to this bug in the MySQL bug stuff but they claim to have eliminated it in 5.0.30... apparently not. I ungraded to version 5.1.32 and the original pro

Re: learning mysql

2009-03-25 Thread George Larson
I'm quite a distance from the best person to answer this question but MySQL has weekly webinars and there are a ton of good tutorials on the web. I started with WAMP (LAMP, MAMP and XAMP are suitable alternatives) and just started reading tutorials. Then I went to the local discount store and got

Re: MySQL server has gone away...

2009-03-25 Thread Walter Heck - OlinData.com
Are you using large blobs by any chance? when max_allowed_packet (google it ;) ) is set too small, the server will also terminate the connection with this error message. Remember to set it correctly at the server and at the client side. One of the better explanations by monty is found here: http:/