MySQL Programs

Mysql having several types of programs:

1) Server programs                        2) Client Programs               3) Utility/Non-Client programs

1) Server programs

      

·     mysqld is the MySQL server.

·     mysqld_safe, mysql.server/mysql, and mysqld_multi are server startup scripts

mysqld_safe is the recommended way to start a mysqld server on Unix and NetWare. mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log file.

mysql.server can be found in the support-files directory under your MySQL installation directory or in a MySQL generic binary or source distribution. In rpm installation /usr/share/mysql/mysql.server. In rpm by default it will be placed in /etc/init.d/mysql 

mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP ports. It can start or stop servers, or report their current status.

·     mysql_install_db initializes the data directory and the initial databases

2) Client Programs

Client programs that access the server:

mysql is a command-line client for executing SQL statements interactively or in batch mode.

mysqladmin is an administrative client.

mysqlcheck performs table maintenance operations.

mysqldump and mysqlhotcopy make database backups.

mysqlimport imports data files.

mysqlshow displays information about databases and tables.

3)Utility/Non-Client programs

Utility programs that operate independently of the server:

myisamchk performs table maintenance operations.

myisampack produces compressed, read-only tables.

mysqlbinlog is a tool for processing binary log files.

perror displays the meaning of error codes.