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…
mysqld_safe – MySQL server startup script Synopsis mysqld_safe optionsDescriptionmysqld_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 section. Note For…
mysqld_multi – manage multiple MySQL servers Synopsis mysqld_multi [options] {start|stop|report} [GNR[,GNR] …]Descriptionmysqld_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 Debian packages includes…
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,…
mysqlbug – generate bug report Synopsis mysqlbugDescriptionTo 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 Unix. The normal…
mysqlbinlog – utility for processing binary log files Synopsis mysqlbinlog [options] log_file …DescriptionThe 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 display the contents…
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_FILEDescriptionThis 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. It also allows…
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]DescriptionThis 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 current audit log…
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,…
mysqladmin – client for administering a MySQL server Synopsis mysqladmin [options] command [command-options] [command [command-options]] …Descriptionmysqladmin 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-arg]] … mysqladmin…
mysqlaccess – client for checking access privileges Synopsis mysqlaccess [host_name [user_name [db_name]]] [options]Descriptionmysqlaccess is a diagnostic tool written by Yves Carlier. It checks the access privileges for a host name, user name, and database combination. Note that mysqlaccess checks access using only the user, db, and host tables. It does not check table, column, or…
mysql_zap – kill processes that match a pattern Synopsis mysql_zap [-signal] [-?Ift] patternDescriptionmysql_zap kills processes that match a pattern. It uses the ps command and Unix signals, so it runs on Unix and Unix-like systems. Invoke mysql_zap like this: shell> mysql_zap [-signal] [-?Ift] pattern A process matches if its output line from the ps command…
mysql_waitpid – kill process and wait for its termination Synopsis mysql_waitpid [options] pidwait_timeDescriptionmysql_waitpid signals a process to terminate and waits for the process to exit. It uses the kill() system call and Unix signals, so it runs on Unix and Unix-like systems. Invoke mysql_waitpid like this: shell> mysql_waitpid [options] pidwait_time mysql_waitpid sends signal 0 to…
mysql_upgrade – check and upgrade MySQL tables Synopsis mysql_upgrade [options]Description Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, see Section 2.11.3, “What the MySQL Upgrade Process Upgrades”). Consequently, mysql_upgrade is unneeded and is deprecated as of that version, and will be removed in a future…