Section 1: user commands and tools
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…
NAME mysqldbcompare – Compare Two Databases and Identify Differences SYNOPSIS mysqldbcompare [options] db1 [:db2] … DESCRIPTION This 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…
NAME mysqld_safe – MySQL server startup script SYNOPSIS mysqld_safe options DESCRIPTION mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. A description of error logging is given later in this…
NAME mysqld_multi – manage multiple MySQL servers SYNOPSIS mysqld_multi [options] {start|stop|report} [GNR[,GNR] …] DESCRIPTION mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP ports. It can start or stop servers, or report their current status. Note For some Linux platforms, MySQL installation from RPM or…
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 mysqlbug – generate bug report SYNOPSIS mysqlbug DESCRIPTION To report MariaDB bugs, see https://mariadb.com/kb/en/mariadb/reporting-bugs/ – the mysqlbug program has now been deprecated by Oracle, and was never useful for MariaDB. Originally, the program enabled you to generate a bug report and send it to Oracle Corporation. It is a shell script and runs on…
NAME mysqlbinlog – utility for processing binary log files SYNOPSIS mysqlbinlog [options] log_file … DESCRIPTION The server’s binary log consists of files containing “events” that describe modifications to database contents. The server writes these files in binary format. To display their contents in text format, use the mysqlbinlog utility. You can also use mysqlbinlog to…
NAME mysqlauditgrep – Search an audit log SYNOPSIS mysqlauditgrep [OPTIONS]… AUDIT_LOG_FILE mysqlauditgrep –file-stats[–format=FORMAT] AUDIT_LOG_FILE mysqlauditgrep –format=FORMATAUDIT_LOG_FILE mysqlauditgrep [–users=USERS] [–start-date=START_DATE] [–end-date=END_DATE] [–pattern=PATTERN[–regexp]] [–query-type=QUERY_TYPE] [–event-type=EVENT_TYPE] [–status=STATUS] [–format=FORMAT] AUDIT_LOG_FILE DESCRIPTION This utility allows you to search the current or archived audit logs, allowing you to display data from the audit log file according to the defined search criterion….
NAME mysqlauditadmin – Maintain the audit log SYNOPSIS mysqlauditadmin [OPTIONS]… mysqlauditadmin [OPTIONS]… [COMMAND]mysqlauditadmin l=user:pass [at] host:port [OPTIONS]… [COMMAND[–value=VALUE]]mysqlauditadmin –file-stats –audit-log-name=FULL_PATHmysqlauditadmin copy –audit-log-name=FULL_PATH –copy-to=DESTINATION [–remote-login=user:host] DESCRIPTION This utility allow you to maintain the m[blue]audit logm[][1], allowing you to monitor the audit log file growth and control its rotation. Rotation refers to the action of replacing the…
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 mysqladmin – client for administering a MySQL server SYNOPSIS mysqladmin [options] command [command-options] [command [command-options]] … DESCRIPTION mysqladmin is a client for performing administrative operations. You can use it to check the server’s configuration and current status, to create and drop databases, and more. Invoke mysqladmin like this: shell > mysqladmin[options] command[command – arg][command[command…