MySQL Bible by Steve Suehring
Wiley | Jul 05 2002 | ISBN: 0764549324 | Pages: 720 | PDF | 6.32 MB
Wiley | Jul 05 2002 | ISBN: 0764549324 | Pages: 720 | PDF | 6.32 MB
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
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.