List of MySQL Programs

<< Introduction of MySQL 5.0 Programs

<< MySQL Tutorials - Herong's Tutorial Notes

This section provides a list of main executable programs provided in MySQL 5.0 Community Edition.

Based on the Community Edition of MySQL 5.0, these are main executable programs provided by MySQL:

• mysqld - The main server program - MySQL server daemon.
• mysqladmin - Command line based administrator tool to manage the server.
• mysql - Command line based user tool to manage databases.
• mysqldump - Tool to dump data from tables into text files.
• mysqlimport - Tool to load data into tables from text files.
• mysqlcheck - Tool to check and repair databases.
• mysqlshow - Tool to display information about databases and tables.
• mysqlbinlog - Tool to process binary MySQL server log files.
• myisamchk - Tool to perform table maintenance operations.
• myisampack - Tool to produce compressed, read-only tables.
• myisamlog - Tool to process the contents of a MyISAM log file.
• isam_ftdump - Tool to display information about FULLTEXT indexes in MyISAM tables.
• mysqlmanager - GUI tool to manage the server.
• perror - Tool to display the meaning of error codes.

Sections in This Chapter

List of MySQL Programs

mysqld - The MySQL Server Program

mysqladmin - The Client Tool for Administrators

mysql - The Client Tool for End Users

Using mysql to Run SQL Statements

mysqldump - Dumping Data to Files

mysqlimport - Loading Data from Files