The Linux Manuals (man pages) document is an important part of Linux documents. Linux Manuals are organized as several sections. Each section has a group of commands for a specific area in Linux usage, administration or development.
mysqlreport – Makes a friendly report of important MySQL status values Syntaxmysqlreport [options] Descriptionmysqlreport makes a friendly report of important MySQL status values. Actually, it makes a friendly report of nearly every status value from SHOW STATUS. Unlike SHOW STATUS which simply dumps over 100 values to screen in one long list, mysqlreport interprets and…
mysqlreplicate – Set Up and Start Replication Between Two Servers Synopsis mysqlreplicate [options]DescriptionThis utility permits an administrator to start replication from one server (the master) to another (the slave). The user provides login information for the slave and connection information for connecting to the master. It is also possible to specify a database to be…
mysqlcheck – a table maintenance program Synopsis mysqlcheck [options] [db_name [tbl_name …]]DescriptionThe mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked with a READ lock only (see Section 13.3.6,…
mysqlpump – a database backup program Synopsis mysqlpump [options] [db_name [tbl_name …]]Description• mysqlpump Invocation Syntax• mysqlpump Option Summary• mysqlpump Option Descriptions• mysqlpump Object Selection• mysqlpump Parallel Processing• mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table…
mysqlprocgrep – Search Server Process Lists Synopsis mysqlprocgrep [options]DescriptionThis utility scans the process lists for the servers specified using instances of the –server option and selects those that match the conditions specified using the –age and –match-xxx options. For a process to match, all conditions given must match. The utility then either prints the selected…
mysqlcheck – a table maintenance program Synopsis mysqlcheck [options] [db_name [tbl_name …]]DescriptionThe mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked with a READ lock only (see Section 13.3.6,…
mysqlmetagrep – Search Database Object Definitions Synopsis mysqlmetagrep [options] [pattern | server] …DescriptionThis utility searches for objects matching a given pattern on all the servers specified using instances of the –server option. It produces output that displays the matching objects. By default, the first nonoption argument is taken to be the pattern unless the –pattern…
mysqlman – default man page for mysql DescriptionCertain executables distributed with the MySQL database management system do not have specific man pages. See AlsoIn most cases, you can run the executable from the command line with a "–help" argument to display a brief summary of the executable’s arguments and function. For more information about MySQL,…
mysqlindexcheck – Identify Potentially Redundant Table Indexes Synopsis mysqlindexcheck [options] db[:table] …DescriptionThis utility reads the indexes for one or more tables and identifies duplicate and potentially redundant indexes. To check all tables in a database, specify only the database name. To check a specific table, name the table in db.table format. It is possible to…
mysqlimport – a data import program Synopsis mysqlimport [options] db_nametextfile1 …DescriptionThe mysqlimport client provides a command-line interface to the LOAD DATA SQL statement. Most options to mysqlimport correspond directly to clauses of LOAD DATA syntax. See Section 13.2.7, “LOAD DATA Statement”. Invoke mysqlimport like this: shell> mysqlimport [options] db_nametextfile1 [textfile2 …] For each text file…
mysqlhotcopy – a database backup program Synopsis mysqlhotcopy argumentsDescriptionmysqlhotcopy is a Perl script that was originally written and contributed by Tim Bunce. It uses FLUSH TABLES, LOCK TABLES, and cp or scp to make a database backup. It is a fast way to make a backup of the database or single tables, but it can…
mysqlfailover – Automatic replication failover Synopsis mysqlfailover [options]DescriptionThis utility permits users to perform replication health monitoring and automatic failover on a replication topology consisting of a master and its slaves. The utility is designed to run interactively or continuously refreshing the health information at periodic intervals. Its primary mission is to monitor the master for…
mysqldumpslow – Summarize slow query log files Synopsis mysqldumpslow [options] [log_file …]DescriptionThe MySQL slow query log contains information about queries that take a long time to execute (see Section 5.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow groups queries that are similar except for the…
mysqldump – a database backup program Synopsis mysqldump [options] [db_name [tbl_name …]]DescriptionThe mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another SQL server. The mysqldump…
mysqldiskusage – Show Database Disk Usage Synopsis mysqldiskusage [options] db …DescriptionThis utility displays disk space usage for one or more databases. The utility optionally displays disk usage for the binary log, slow query log, error log, general query log, relay log, and InnoDB tablespaces. The default is to show only database disk usage. If the…
mysqldiff – Identify Differences Among Database Objects Synopsis mysqldiff [options] {db1[:db1] | {db1.obj1[:db2.obj2]} …DescriptionThis utility reads the definitions of objects and compares them using a diff-like method to determine whether they are the same. The utility displays the differences for objects that are not the same. Use the notation db1:db2 to name two databases to…
mysqldbimport – Import Object Definitions or Data into a Databases Synopsis mysqldbimport [options] import_file …DescriptionThis utility imports metadata (object definitions) or data or both for one or more databases from one or more files. If an object exists on the destination server with the same name as an imported object, it is dropped first before…
mysqldbexport – Export Object Definitions or Data from a Database Synopsis mysqldbexport [options] db_name …DescriptionThis utility exports metadata (object definitions) or data or both from one or more databases. By default, the export includes only definitions. mysqldbexport differs from mysqldump in that it can produce output in a variety of formats to make your data…
mysqldbcopy – Copy Database Objects Between Servers Synopsis mysqldbcopy [options] db_name [:new_db_name]DescriptionThis utility copies a database on a source server to a database on a destination server. If the source and destination servers are different, the database names can be the same or different. If the source and destination servers are the same, the database…
mysqldbcompare – Compare Two Databases and Identify Differences Synopsis mysqldbcompare [options] db1 [:db2] …DescriptionThis utility compares the objects and data from two databases to find differences. It identifies objects having different definitions in the two databases and presents them in a diff-style format of choice. Differences in the data are shown using a similar diff-style…