Customer Reviews

MySQL Bible with CDROM

5 star:		(4)
4 star:		(1)
3 star:		(1)
2 star:		(4)
1 star:		(2)

 

 

I've read Kofler's and DuBois's books and if I had it to do over, I would pass on this book only because the combination of the other two make this book superfluous. Kofler & DuBois combined come closer to providing a comprehensive overview of MySQL.

There are a few things buyers should know about this book.

The CD does NOT contain the bulk of the examples. You're in for lots of typing if you want to follow along. Those unwilling to labor away at their keyboards might not notice that the examples have problems.

The lack of an author designed and organized structure of examples leads to other problems because clearly the author had a structure in mind, but the reader is left to deduce this along the way after he/she has possibly already created a different structure as I did. Not providing the examples in an organized manner is the primary cause of many other issues.

The examples assume you can use your knowledge to adjust them or your operating environment to make them work. You have to learn to "read between the lines". Someone learning about MySQL may also be seeing PHP or PERL for the first time, so I don't think it's reasonable to have the reader make up for what the author failed to provide. Assumptions are made about where things are located and what they're called.
`Oh - I see - he wants a chap16 subdirectory.'
`Ah - he wants to call this file fig18.php - wouldn't grants.php make more sense so when I look in that directory a month from now I can find the routine that did grant lookup, especially since the next example wants to be called signin.php?'

Had the author supplied the examples in a structure containing chapter subdirectories, then his examples might make more sense. As it is, you're left to create a structure, or fix the code to meet your needs. People purchasing a book to learn from may or may not possess the knowledge to make the alterations and continue on. It's an easily avoidable stumbling point with a little effort from the author and publisher.

The PHP examples assume a version older than PHP 4.2. You'll have to upgrade the examples yourself if you want to use a PHP 4.2.x flavor. For a book published mid 2002, that's a bit of an oversight. BTW - Kofler's WEB site provide downloadable PHP 4.2 versions of his examples, and his book was published in 2001. Mr. Kofler's willingness to maintain his work over time and provide conversion functions allowed me to make Mr. Suehring's examples work under PHP 4.2.1. Thank You Mr. Kofler!

The CD does contain a PDF version of the book, but you can't copy the examples from it to eliminate typing them. Largely, the CD holds installable software for Perl, Acrobat, PHP, Apache, etc, things easily found on the WEB, so it was of no value to me. Actually, the availability of the CD wasted my time. I just knew the examples had to be on the CD somewhere, probably misfiled, so I examined every file. They're not there. ;-(

There are no errata for the book that I can locate at the time I write this. The authors WEB site hardly mentions the book. I've discovered numerous errors, and brought some to the author's attention. I can't spend my time proof reading his book however.

The example code is sloppy, although you can get the point the author is trying to make if you are already somewhat conversant in MySQL and Perl or PHP. A newbie might have a problem however.

For example, the author creates a function (priv) which executes mysql_query($query). $query is built inside the priv function using several passed in parameters. The function should make sure that those passed in parameters are safe to send to MySQL by applying mysql_escape_string on them. That's not done however. The author chooses to use mysql_escape_string before calling the priv function, and then codes the priv function call incorrectly by referencing the unsafe parameters by mistake.
i.e. Page 476
$quoteduser = mysql_escape_string($user);
$quotedhost = mysql_escape_string($inhost);
priv($user, $inhost);

Page 483 holds my favorite example of sloppy code. The same 6 lines of code are repeated 3 times in a convoluted if /elseif statement. This page also repeats the error previously mentioned.

Mr. Suehring also dispenses with any of the typical starting and ending HTML code that should be in every page. Reading his code fosters sloppy coding practices. Using "View Source" from a browser reveals that his output pages aren't what you would expect to see.

The author apparently worked from a Windows machine and used an SSH tool called Putty to SSH into a Linux machine where the actual MySQL server was running. The book is chock full of screen shots of these Putty/SSH sessions. Each one is very difficult to read since the screen shot is solid black background with thin, tiny font, gray output that lacks contrast. Think about it - tiny grey text on a black background.

Had the author provided the publisher with textual examples, and the publisher had appropriately formatted them to simulate a screen shot the book would be a much easier read. As it is, I used a magnifying glass to read those black smudges. I fault the publisher for allowing this to occur. Of the numerous sample pages that Amazon makes available for review, not one of them shows a single screen shot so you'll have to use your imagination.

Maybe a second edition of the MySQL Bible, coupled with a WEB site that provides updated downloadable examples and errata will correct its shortcomings.

I have to disagree with many of the reviews of this book.

The MySQL Bible would benefit from more than a simple layout change. Since the advent of the win installer for ver. 4.1.6 gamma of MySQL, the first 5 chapters of this book become useless. There are few explicit example of code (especially regarding how to interact with mysqladmin) extracted from the impossible "dark grey on black" screen captures that are used.

As for the comment that some reviewers have made, that some of the codes provided (when they can be read) are inaccurate or ineffective, I would add only that I have yet to find a snippet of code in the book that actually works.

Maybe there is something usefull in this book, but I haven't found it yet... I only hope that this book has a major revision for 5.0, and that someone in the editorial dept. at Wiley actually looks at pages before they are published.

I purchased this book with great anticipation of expanding my knowledge of mySQL and making great us of the section on perl. Overall, I'm very dissapointed. The book itself goes into great detail about certain things that need not such a vast description, yet only privide single examples for some important things.
The CD-ROM is useless. I was expacting it to have code from the book, whereas it's a collection of mySQL apps and programs that you can get free elswhere.
Having explored the perl chapter of the book in greatest detail, it provides inadequite examples with a lot of inneficient coding.
I give the book credit, however, for covering as much ground as it does, mySQL with perl, PHP and ODBC. Overall, however, not worth the money.

I hate to admit that I was suckered into buying this book. I was looking for a decent book to help we with the administration of MySQL. Unfortunately this book only slowed me down by providing samples that were unclear and in some cases just wrong. In the end I waded through the documentation for MySQL on the web and found the correct answers that just were not present in the book.

Just to give some examples of things that were wrong: the binary distribution summaries are not accurate as described on page 57. The syntax for changing the root password was also wrong on page 62. These are critical things to have wrong in a book called a "Bible".

I had been relying on a combination of the online HTML ref docs and Michaeal Kofler's "MySQL" book for the last six months. I think this book is far better than Kofler's in terms of it's thorough coverage of MySQL and integration with other systems and programming languages. I also like this book's intuitive style and timely informational tidbits. Very Highly Recommended.

Unfortunately, time and development have passed this book by. It is for MySQL 4.0, which has been FAR surpassed by the newer 5.0 version.

As mentioned by some other reviewers, one of the main problems with the book is the illustrations. They are so dark as to be illegible. Not sure what the people that got the press proofs were thinking when they let that out the door.

The author does a reasonable job on certain areas (hey, can't be all bad if he has a dedication to Eddie Van Halen).

Might want to try the third edition of MySQL by Paul DuBois as a good reference book that is much more up-to-date.

This is an excellent book. Buy it.

However, the entire book uses actual screen shots to demonstrate the bulk of all the command line examples. These screen shots are huge blocks of black background containing tiny, faint, thin grey lettering. Think about it - thin grey letters on a black background.

Apparently, the author used a Windows box running Putty to SSH into a Linux box running the actual MySQL database server. The screen shots are of actual Putty/SSH sessions.

Although you can see some of the books pages online, none of them contains a single example of what I'm referring to. The book is chock full of them.

I don't care how good your vision is, reading the contents of these screen shots is needlessly difficult. I used a large magnifying glass and I have 20/20 vision. If the author had supplied the publisher with text equivalents, AND if the publisher had formatted those examples properly, it would be a much better read.

It still gets 5 stars for content. The Publisher gets 0 stars for allowing this to happen.

I've also read Koffler's book and of course, DuBois's excellent tome. If I had it to do over again, I'd still purchase all three.

Anyone with vision problems, take note.

Very good book. I'll recomend it to anyone learning MySQL.

Some examples did not work in my server but after contacting the author we/he resolved the problem. Problem was related to new release of PHP. The CD-ROM does not include the examples so be ready to do some typing.

The pictures in the book are hard to see.

Book content *****
Book layout ***
CD-ROM **
Author's support *****

I found this book to be quite helpful. Luckily, the author assumes you have some knowledge of MySQL. Content is excellent. I'd recommend it as an addition to a programming library.

Don't waste your money on this. The book and reviews claim to include binaries and source of MySQL database but the CD-ROM contains neither. Bogus.