Utilities and Programs for MySQL

In addition to the MySQL database server (mysqld), the MySQL “suite” includes a number of programs for administering the databases and the database server. These programs were installed when you installed via the RPM. isamchk and myisamchk are utilities that verify and repair database tables and files. mysqlaccess is used to grant, modify, and revoke user permissions. mysqladmin is a utility for higher-level administration, such as creating databases and shutting down the myslqd server. mysqldump comes in handy for exporting data or backing up tables in a pinch; it outputs data in SQL insert statements in such a way that the output file can be fed back into a MySQL server (or other database) and the rows will ...

Get MySQL Building User Interfaces now with O’Reilly online learning.

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