Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




4.1. Overview of MySQL Programs

MySQL AB provides several types of programs:

  • The MySQL server and server startup scripts:

    • mysqld is the MySQL server.

    • mysqld_safe, mysql.server, and mysqld_multi are server startup scripts.

    • mysql_install_db initializes the data directory and the initial databases.

    • MySQL Instance Manager monitors and manages MySQL Server instances.

    Chapter 5, Database Administration, discusses these programs further

  • 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.

    Chapter 8, Client and Utility Programs, discusses these programs further

  • 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.

    Chapter 5, Database Administration, discusses myisamchk. Chapter 8, Client and Utility Programs, discusses the other programs.

Most MySQL distributions include all of these programs, except for those programs that are platform-specific. (For example, the server startup scripts are not used on Windows.) The exception is that RPM distributions are more specialized. There is one RPM for the server, another for client programs, and so forth. If you appear to be missing one or more programs, see Chapter 2, Installing and Upgrading MySQL, for information on types of distributions and what they contain. It may be that you have a distribution that does not include all programs and you need to install something else.

  Published under the terms of the GNU General Public License Design by Interspire