Chapter 11. General MySQL Administration
If you're acting as your site's MySQL administrator, this chapter discusses what you'll need to do to keep MySQL running smoothly. It covers how to carry out the following responsibilities:
These chapters cover several programs that are essential for MySQL administrators to know about:
Much of the information in this chapter can be better appreciated if you have an understanding of MySQL's data directory, which is where the server stores databases, log files, and other information. For more information, see Chapter 10, "The MySQL Data Directory." Additional information specific to the SQL statements and programs discussed here is provided in Appendix E, "SQL Syntax Reference," and Appendix F, "MySQL Program Reference."
For simplicity, most of the Windows-related material in this chapter assumes that MySQL is installed at C:\mysql. However, beginning with MySQL 4.1.5, MySQL AB provides an installation wizard that likes to install the distribution under C:\Program Files\MySQL\MySQL ServerX.Y, where X.Y is a number like 4.1. If you use that installation location, be sure to adjust Windows pathnames shown in this chapter accordingly.