Section 1: user commands and tools
NAME mysqueak – desktop frontend to Squeak SYNOPSIS mysqueak DESCRIPTION mysqueak runs inisqueak in batch mode in the directory ~/MySqueak/default. If that directory does not exist it will be created, and inisqueak will populate it with an image file. The primary purpose of mysqueak is to simplify starting Squeak from a menu, though it also…
NAME mysqluserclone – Clone Existing User to Create New User SYNOPSIS mysqluserclone [options] base_usernew_user[:password][@host_name] … DESCRIPTION This utility uses an existing MySQL user account on one server as a template, and clones it to create one or more new user accounts with the same privileges as the original user. The new users can be created…
NAME mysqluc – Command line client for running MySQL Utilities SYNOPSIS mysqluc [–help | –version | [ | –verbose | –quiet |] –width=<num> | –utildir=<path> | –execute <command list> <variable>=<value>] DESCRIPTION This utility provides a command line environment for running MySQL Utilities. The mysqluc utility, hence console, allows users to execute any of the currently…
NAME mysqltest – program to run test cases mysqltest_embedded – program to run embedded test cases SYNOPSIS mysqltest [options] [db_name] mysqltest_embedded [options] [db_name] DESCRIPTION The mysqltest program runs a test case against a MariaDB server and optionally compares the output with a result file. This program reads input written in a special test language. Typically,…
NAME mysqltest – program to run test cases mysqltest_embedded – program to run embedded test cases SYNOPSIS mysqltest [options] [db_name] mysqltest_embedded [options] [db_name] DESCRIPTION The mysqltest program runs a test case against a MariaDB server and optionally compares the output with a result file. This program reads input written in a special test language. Typically,…
NAME mysqlslap – load emulation client SYNOPSIS mysqlslap [options] DESCRIPTION mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. It works as if multiple clients are accessing the server. Invoke mysqlslap like this: shell> mysqlslap [options] Some options such as –create or…
NAME mysqlshow – display database, table, and column information SYNOPSIS mysqlshow [options] [db_name [tbl_name [col_name]]] DESCRIPTION The mysqlshow client can be used to quickly see which databases exist, their tables, or a table’s columns or indexes. mysqlshow provides a command-line interface to several SQL SHOW statements. See Section 13.7.7, “SHOW Statements”. The same information can…
NAME mysqlserverinfo – Display Common Diagnostic Information from a Server SYNOPSIS mysqlserverinfo [options] db1 [:db2] … DESCRIPTION This utility displays critical information about a server for use in diagnosing problems. The information displayed includes the following: • Server connection information • Server version number • Data directory path name • Base directory path name •…
NAME mysqlrplshow – Show Slaves for Master Server SYNOPSIS mysqlrplshow [options] DESCRIPTION This utility shows the replication slaves for a master. It prints a graph of the master and its slaves labeling each with the host name and port number. You must specify the –discover-slaves-login option to provide the user name and password to discover…
NAME mysqlrplcheck – Check Replication Prerequisitiess SYNOPSIS mysqlrplcheck [options] DESCRIPTION This utility checks the prerequisites for replication between a master and a slave. These checks (called tests) are designed to ensure a healthy replication setup. The utility performs the following tests: 1. Is the binary log enabled on the master? 2. Are there binary logging…
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…