Synopses & Reviews
"The MySQL Bible introduces the essential concepts and skills you'll need to get started with MySQL."
- Jeremy Zawodny, Senior Editor of Linux Magazine and the MySQL database expert at Yahoo! Finance
If MySQL can do it, you can do it too . . .
MySQL is the leading open source relational database management system. It's powerful, it's stable, and best of all, it's free. Covering everything from RDBMS basics to advanced topics such as replication, database veteran Steve Suehring shows you how to put together and maintain your own MySQL database system. Whether you're a database newcomer who needs help with the command line interface, an administrator who wants tips on security and performance tuning, or a developer looking for the lowdown on building MySQL-enabled Perl, PHP, Java, and ODBC applications, this is the only guide you need to harness the power of MySQL.
Inside, you'll find complete coverage of MySQL
* Install MySQL on a Linux, Windows, or Mac system
* Get the scoop on database design
* Take control of MySQL using the command line interface
* Configure MySQL for any sized system and implement security
* Debug databases and servers and tune performance
* Build applications using Perl, PHP, and ODBC
* Find out how to handle MySQL replication
* Integrate Linux services with PAM-MySQL/NSS-MySQL
* Harness NuSphere enhancements to MySQL
* Use phpMyAdmin for MySQL administration through the Web
Bonus CD-ROM
* Sample code from the book
* Perl DBI
* PHP and phpMyAdmin
* Apache
Synopsis
- Organization: The book is divided into five parts: Getting Starated with MySQL and Relational Databases; Understanding SQL Through MySQL; MySQL Administration; MySQL Developer Guide; and Advanced and Specialized MySQL Topics.
- Comprehensive coverage: This Bible covers both beginning-level and advanced topics. Topics covered include: introduction to relational database management; installing and configuring MySQL on the Linux, Windows 2000, and Mac OS X operating systems; MySQL security; debugging and repairing MySQL databases and servers; MySQL performance tuning; and developing MySQL applications with Perl and PHP.
- Coverage of NuSphere MySQL: Due to the growing popularity of the NuSphere MySQL package, this book covers its enhancements and how to install and develop with NuSphere MySQL.
- Running database application: This book builds an e-commerce sample database application throughout to demonstrate concepts and topics.
ABOUT THE CD-ROM:
What's on the CD-ROM: The CD-ROM includes the latest version of MySQL (either Version 4.0 or 4.1); sample database application and code in the book; and PHP and Perl.
About the Author
Steve Suehring (Stevens Point, Wisconsin) is currently a Systems Engineer at CoreComm, a 350,000-user Internet Provider. In addition to his other responsibilities, Steve maintains authentication infrastructure using MySQL as the database backend. Steve has built numerous applications with both the Oracle and MySQL databases. He is a Microsoft Certified Systems Engineer, Cisco Certified Design Associate, and Cisco Certified Network Professional. Steve has also written articles for Linux Magazine.
Table of Contents
Preface.
Acknowledgments.
PART 1: Getting Started.
Chapter 1: Relational Database Management.
Chapter 2: Preparing for Installation
Chapter 3: Linux Installation.
Chapter 4: Windows Installation.
Chapter 5: Macintosh Installation.
Chapter 6: Starting MySQL.
Chapter 7: Database Concepts and Design.
PART II: SQL Essentials.
Chapter 8: Command Line Interface (CLI).
Chapter 9: SQL According to MySQL.
Chapter 10: Database and Data.
PART III: Administration.
Chapter 11: Server Configurations.
Chapter 12: Security.
Chapter 13: Debugging and Repairing Databases.
Chapter 14: Performance Tuning.
PART IV: Development.
Chapter 15: Perl Development.
Chapter 16: PHP Development.
Chapter 17: ODBC/JDBC.
PART V: Advanced Performance.
Chapter 18: Replication.
Chapter 19: Integration of Internet Services.
Chapter 20: NuSphere Enhanced MySQL.
PART VI: Appendixes.
Appendix A: Application Reference.
Appendix B: Language Reference.
Appendix C: Function and Operator Reference.
Appendix D: Datatype Reference.
Appendix E: Glossary.
Appendix F: About the CD-ROM.
Index.