Written by the creators of MySQL and edited by one of the most highly respected MySQL authors, the MySQL Administrator’s Guide and Language Reference is the official guide to installing MySQL, to setting up and administering MySQL databases, and to storing and retrieving data in these databases. This new edition combines into one book the MySQL Language Reference (on CD) with the practical information of the MySQL Administrator’s Guide book.

Paul DuBois is the leading author of books on MySQL topics. His book, MySQL (0672326736), is considered the definitive guide to using, administering and programming MySQL. He is currently an employee of MySQL AB and is in charge of editing and maintaining the official English-language documentation for MySQL.

With more than 4 million active installations, MySQL is the world’s most popular open-source database. Known for its speed, high reliability, and ease of use, MySQL is rapidly becoming a low-cost alternative to high-priced, high-maintenance database systems from Oracle, IMB and Microsoft-and it already has more users than any of these more established proprietary databases. The MySQL User’s Guide is the only official guide to installing MySQL, to setting up and administering databases, and to storing and retrieving data in these databases. Written by the creators of MySQL, and edited by the highly respected MySQL authors, the MySQL User’s Guide is designed for a broad audience. Non-programmers and programmers alike will be able to quickly get up-to-speed with MySQL using the clear instructions, examples, and tips provided in the book.

<>Written by the creators of MySQL and edited by one of the most highly respected MySQL authors, the MySQL Administrator’s Guide and Language Reference is the official guide to installing MySQL, to setting up and administering MySQL databases, and to storing and retrieving data in these databases. This new edition combines into one book the MySQL Language Reference (on CD) with the practical information of the MySQL Administrator’s Guide book. 

 

 

Written by the creators of MySQL and edited by one of the most highly respected MySQL authors, theMySQL Administrator's Guide, Second Edition is the official guide to installing MySQL, to setting up and administering MySQL databases, and to storing and retrieving data in these databases. This new edition combines into one book the MySQL Language Reference (on CD) with the practical information of the original book. Along with the MySQL Developer's Guide, the MySQL Administrator's Guide offers the in-depth coverage essentials for MySQL.

 

 

MySQL Admin Guide
Excellent delivery service and the condition of the book was new. The price was also excellent.

Excellent -- if your running version 5
This is an excellent book, but it is written for MySql 5. Check your version before buying.

Get the newer edition
Good stuff. But the MySQL Administrator’s guide (2nd edition) and Language reference is out and on Amazon. That contains the same book in a later edition with the language reference on CD on top of it. Buy that instead.

Good Buy
This is a good book gives out the details in an easy to understand format.

Language Reference only on CD
The title is slightly confusing. The "Administrator’s Guide" is the only bit that comes in printed form. The "Language Reference" is only included as a PDF on the accompanying CD.

Language Reference only on CD
The title is slightly confusing. The "Administrator’s Guide" is the only bit that comes in printed form. The "Language Reference" is only included as a PDF on the accompanying CD.

Well Worth It
The MySQL Administrator’s Guide by MySQL Press is the ultimate reference for anyone installing, upgrading or maintaining the MySQL database server. I found this guide to be completely invaluable when using MySQL, even before I had downloaded the software. The Guide uses clear, easy to read, formatting which makes shell instructions stand out from MySQL statements. A detailed index takes no time to show you where in 600 pages your answer lies. And you can bet you’ll find the answer in this Guide. Beginners beware, however, this is no introduction to MySQL. Readers should have a clear understanding of their system, along with experience of MySQL, although an insight into MySQL AB and MySQL’s history is included in Chapter 1.

As I began reading through this Guide, I couldn’t help notice immediately how it sets itself apart from similar books. The MySQL Admin Guide has a detail which you will not find anywhere else. Such is to be expected from the company who make the software, and this book certainly shows the high quality of MySQL. After reading through this book, I can’t help but agree with Kaj Arno (Vice President Software Engineering, MySQL AB) who is quoted on the back page; "’It is not possible to find a more thorough and more current reference in print, anywhere’". One of the best example I can make of this fact is in Chapter 2 which focuses on Installing MySQL. Not only does this Guide list all the option of a source distribution, all the ins and outs of installing MySQL on all likely platforms - Windows, Mac OS X, NetWare, Linux and other general Unix systems - this guide also deals with Upgrading and Downgrading the most recent version of the MySQL database server. And of course, to ensure that the entire knowledge is in print, Perl installation notes are included too. What other book covers the often troublesome installation process in almost 150 pages of detail?

And that’s only the second chapter. Throughout the book you’re assured to find comprehensive information straight from the people who know it best. You may think that this book simply offers too much information, and for most people I would have to agree. It is unlikely to bother a system administrator how MySQL server optimizes the WHERE clause, or how to avoid table scans. Even if someone was interested in understanding something like this, they’d have the opportunity of looking at the MySQL Reference Manual online. So why buy the print version? The printed Guide not only allows for offline viewing, it also includes information which has not been included in the Reference Manual, such as how details are stored and the many feature of MySQL’s MaxDB. If your not content with only having part of the story, you’ll want to get this Guide.

The MySQL Administrator’s Guide is the ideal book for system administrators who want to get the most out of their MySQL server. With all the advice on installing, maintaining and administering that you’ll ever need to know, this Guide by MySQL AB is ideal for those who long for a comprehensive printed reference.

extensive documentation
With what appears to be stunning speed, the open source relational database known as MySQL has been installed on many thousands of sites. Of course, the cost-free nature is its best selling point. With its rise, so too is the necessity for books like this.

Its bulk should be reassuring. The MySQL company has put a lot of sweat into making the manual as extensive as possible. Not light reading. But the individual sections should be within your grasp, if you have some sysadmin experience. For example, the introductory sections that deal with installations are on a par of complexity comparable to installing GCC or Tomcat. Not a one click installation. Because MySQL offers a lot of configuration options, if you go with a source distribution.

The toughest part may be later, when you have a populated database and you want to optimise it. Unsurprisingly, you will need good prior background in SQL. Take note that this book does not teach you SQL, per se. That is properly the remit of another text.

By the way, the book mentions that (finally) stored procedures are implemented. In version 5. Other database vendors, like IBM and Oracle, have had this ability for years, and have hammered on MySQL for its lack. Here, the book could do with an expanded discussion of how to use these procedures. It just has a cursory note. Hopefully, the next edition will improve on this. Because stored procedures are an important performance optimiser in many large databases.