Command-Line Interfaces for MariaDB Enterprise Server

Overview

MariaDB Enterprise Server includes several command-line interfaces that are used to manage and operate on MariaDB database products.

Reference material is available for MariaDB Enterprise Server.

MariaDB Enterprise Server CLIs

MariaDB Enterprise Server includes several command-line interfaces.

Choose a command-line interface to find out more information about how to use each one:

CLI

Use Case

innochecksum

A utility to check InnoDB data files

mariadb / mysql

MariaDB Client is used to connect to MariaDB Enterprise Server and other MariaDB database products, execute queries, and perform operations

mariadbd / mysqld

The server binary for MariaDB Enterprise Server

mariadb-admin / mysqladmin

MariaDB Admin is used to perform certain administrative tasks with MariaDB Enterprise Server

mariadb-backup / mariabackup

MariaDB Enterprise Backup is used to perform physical backups of MariaDB Enterprise Server

mariadb-binlog / mysqlbinlog

MariaDB Binlog is used to read binary logs

mariadb-check / mysqlcheck

MariaDB Check is used to check and repair tables

mariadb-dump / mysqldump

MariaDB Dump is used to perform logical backups of MariaDB Enterprise Server

mariadb-import / mysqlimport

MariaDB Import is used to load tables using data from text files

mariadb-plugin / mysql_plugin

MariaDB Plugin installs plugins

mariadb-show / mysqlshow

MariaDB Show is used to show the structure and other details about database objects

mariadb-slap / mysqlslap

MariaDB Slap is used for load testing

mariadb-upgrade / mysql_upgrade

MariaDB Upgrade is used to upgrade a database directory's format after a server upgrade

mariadb-waitpid / mysql_waitpid

Used to kill processes

my_print_defaults

This utility is used to print options that are set in configuration files

perror

This utility accepts error codes as input and displays detailed descriptions of the errors

resolve_stack_dump

This utility resolves numeric stack dumps

resolveip

This utility resolves IP addresses and host names

CLI

Use Case

mariadb / mysql

MariaDB Client is used to connect to MariaDB Enterprise Server and other MariaDB database products, execute queries, and perform operations

mariadb-backup / mariabackup

MariaDB Backup is used to perform physical backups of MariaDB Enterprise Server

mariadb-dump / mysqldump

MariaDB Dump is used to perform logical backups of MariaDB Enterprise Server

mariadb-import / mysqlimport

MariaDB Import is used to load tables using data from text files