MySQL Admin Cookbook
This book uses the approach of a cookbook, presenting solutions to problems in the form of recipes. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. Example values and code samples are used throughout the recipes, which makes adaptation for individual needs easy Administrators of all skill-levels will find step-by-step instructions for practical approaches to MySQL configuration, maintenance, and optimization topics. Each recipe uses a concrete example for easy understanding. This book is for ambitious MySQL users as well as professional data center database administrators. Beginners as well as experienced administrators will profit from this cookbook and get fresh ideas to improve their MySQL environments. Detailed background information will enable them to widen their MySQL horizon. It does not cover SQL basics, how to install MySQL servers, or how to design a relational database schema. Readers are expected to have a basic understanding of the SQL language and database concepts in general.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Other editions - View all
admin4mysql allows ALTER TABLE AppArmor autoextending autoincrementing backup backup_usr basic binary logs blacktest bytes character sets columns compression configuration file connection copy CREATE TABLE data files database server Defining DELETE disk doit emp_no ENGINE=InnoDB example execute export following command Foreign key Getting ready GUI Tools gzip host Howit Howitworks howto InnoDB tables InnoDB tablespace INSERT statements installation inthe isnot large tables Linux Linux distributions Mac OS X machine master modify MyISAM MySQL Administrator mysql commandline client MySQL configuration MySQL instance MySQL server MySQL user mysqldump Note ofthe onthe operating system option output performance previous recipe primary key problem records replication requirements restart restore rows affected schema script SELECT SELinux slave space specific SQL dump SQL statements steps storage engine stored procedure sure TABLE statement target theMySQL There's tothe UPDATE user account username values VARCHAR variable Windows youwill