13. MySQL Administration

There are several facets to administering a MySQL server, from the obvious and critical backing up of data to improving security and performance. Fortunately the reliability of MySQL demands little in the way of maintenance, but should the need arise, this, too, is easily accomplished.

Historically, pretty much every administrative task could be accomplished using one of two methods. First, there are several utilities that MySQL distributes with the server itself. These are each run from a command-line interface, just like the mysql client. Second, most tasks can also be accomplished within the mysql client using the proper SQL command. I will briefly mention these options, as applicable, for the tasks I discuss in this ...

Get MySQL, Second Edition: Visual Quickstart Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.