NAME mysqlrpladmin – Administration utility for MySQL replication SYNOPSIS mysqlrpladmin [options] DESCRIPTION This utility permits users to perform administrative actions on a replication topology consisting of a master and its slaves. The utility is designed to make it easy to recover from planned maintenance of the master or from an event that takes the master…
NAME mysqlreport – Makes a friendly report of important MySQL status values SYNTAX mysqlreport [options] DESCRIPTION mysqlreport 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,…
NAME mysqlreplicate – Set Up and Start Replication Between Two Servers SYNOPSIS mysqlreplicate [options] DESCRIPTION This 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…
NAME mysqlcheck – a table maintenance program SYNOPSIS mysqlcheck [options] [db_name [tbl_name …]] DESCRIPTION The 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…
NAME 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…
NAME mysqlprocgrep – Search Server Process Lists SYNOPSIS mysqlprocgrep [options] DESCRIPTION This 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…
NAME mysqlcheck – a table maintenance program SYNOPSIS mysqlcheck [options] [db_name [tbl_name …]] DESCRIPTION The 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…
NAME mysqlmetagrep – Search Database Object Definitions SYNOPSIS mysqlmetagrep [options] [pattern | server] … DESCRIPTION This 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…
NAME mysqlman – default man page for mysql DESCRIPTION Certain executables distributed with the MySQL database management system do not have specific man pages. SEE ALSO In 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…
NAME mysqlindexcheck – Identify Potentially Redundant Table Indexes SYNOPSIS mysqlindexcheck [options] db[:table] … DESCRIPTION This 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…
NAME mysqlimport – a data import program SYNOPSIS mysqlimport [options] db_nametextfile1 … DESCRIPTION The 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…
NAME mysqlhotcopy – a database backup program SYNOPSIS mysqlhotcopy arguments DESCRIPTION mysqlhotcopy 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,…
NAME mysqlfailover – Automatic replication failover SYNOPSIS mysqlfailover [options] DESCRIPTION This 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…
NAME mysqldumpslow – Summarize slow query log files SYNOPSIS mysqldumpslow [options] [log_file …] DESCRIPTION The 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…
NAME mysqldump – a database backup program SYNOPSIS mysqldump [options] [db_name [tbl_name …]] DESCRIPTION The 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…
NAME mysqldiskusage – Show Database Disk Usage SYNOPSIS mysqldiskusage [options] db … DESCRIPTION This 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…
NAME mysqldiff – Identify Differences Among Database Objects SYNOPSIS mysqldiff [options] {db1[:db1] | {db1.obj1[:db2.obj2]} … DESCRIPTION This 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…
NAME mysqldbimport – Import Object Definitions or Data into a Databases SYNOPSIS mysqldbimport [options] import_file … DESCRIPTION This 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…
NAME mysqldbexport – Export Object Definitions or Data from a Database SYNOPSIS mysqldbexport [options] db_name … DESCRIPTION This 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…
NAME mysqldbcopy – Copy Database Objects Between Servers SYNOPSIS mysqldbcopy [options] db_name [:new_db_name] DESCRIPTION This 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…