Overview of MySQL Programs

There are many programs in a MySQL installation. Let us see an overview of some of the programs. Some programs are platform−specific, which means they are not present in all of MySQL distributions.

Every MySQL program takes different options. There is a ‘- - help’ option that can be used to get a description of the program’s different options. The default option values can be overridden for MySQL program, by specifying options on command line or in an option file.

Every MySQL program takes different options. There is a ‘- - help’ option that can be used to get a description of the program’s different options. The default option values can be overridden for MySQL program, by specifying options on command line or in an option file.

• mysqld − It is the SQL daemon (MySQL server). Client programs can be used if mysqld is running, since clients gain access to databases by connecting to the server.

• mysqld_safe − It is a server startup script. The ‘mysqld_safe’ tries to start mysqld.

• mysqld_multi − It is a server startup script that can start or stop multiple servers that are installed on the system.

• comp_err − It is used during the MySQL build/installation process. It compiles error message files from the error source files.

• mysql_secure_installation − The program enables user to improve the security of your MySQL installation.

• mysql_tzinfo_to_sql − It is the program loads the time zone tables in the mysql database with the help of the contents of the host system zoneinfo database.

• mysql − It is the command-line tool for interactively entering SQL statements or executing them from a file in batch mode.

• mysqladmin − It is a client that performs administrative operations, like creating or dropping databases, reloading the grant tables, flushing tables to disk, and reopening log files. The ‘mysqladmin’ can also be used to retrieve version, process, and status information from the server.

• mysqlcheck − It is a table-maintenance client that checks, repairs, analyzes, and optimizes tables.

• mysqldump − It is a client that dumps a MySQL database into a file as SQL, text, or XML.

• mysqlimport − It is a client which imports text files into their respective tables using LOAD DATA.

• mysqlpump − It is a client that dumps a MySQL database into a file as SQL.

• mysqlshow − It is a client which displays information about databases, tables, columns, and indexes.

• mysqlslap − It is a client designed to emulate client load for a MySQL server and report the timing of every stage. It works as though multiple clients are accessing the server.