Introduction of MySQL 5.0 Programs

<< MySQL Tutorials - Herong's Tutorial Notes

This chapter provides notes and tutorial examples on MySQL 5.0 programs. Topics include a list of MySQL 5.0 main programs; introduction of mysqld, mysqladmin, mysql, mysqldump, and mysqlimport.

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

Conclusions:

• MySQL 5.0 provides one server program, mysqld.
• MySQL 5.0 provides two main client programs, mysqladmin - the server administrator tool, mysql the end user tool.
• MySQL 5.0 also provides tools to dump data to files, mysqldump, and import dat from files, mysqlimport.