MySQL Utilities
MySQL comes with several utility programs and scripts, located in the /usr/local/mysql/bin and /usr/local/mysql/scripts directories. All the MySQL utilities include a --HELP option that provides a full description of the program's different options.
isamchk— Utility to describe, check, optimize, and repair MySQL tables.
mysqlaccess— Script that checks access privileges.
mysqladmin— Utility for performing administrative operations.
mysqldump— Dumps a MySQL database into a file as SQL statements or as text.
mysqlimport— Imports text files into tables.
mysqlshow— Lists information about databases, tables, columns, and indexes.
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
