O'Reilly logo

MySQL, Second Edition: Visual Quickstart Guide by Larry Ullman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required