Mysqldump

mysqldump a backup program.

Usage

• mysqldump database_name > database_name.sql
  • Compressing from stdin mysqldump database_name | gzip > database_name.sql.gz
  • Compressing from stdin mysqldump database_name | xz -T0 > database_name.sql.xz

Related commands

• mongodump
• mariabackup

See also

• MariaDB: mariadbcheck, mariabackup, mysqldump, MyRocks, show (MariaDB) MariaDB Changelog, 50-server.cnf, MariaDB engines, .ibd, .myd, .myi, /var/log/mysql/error.log, MariaDB files: .frm, .ibd, /etc/mysql/mariadb.conf.d/50-server.cnf, replication, MariaDB slow queries, show databases;, Aria, MyISAM, MariaDB SkySQL, binary log, 3306
• XtraBackup and MyDumper
• MongoDB: mongodump, PostgreSQL: pg_dump, MariaDB: mysqldump

https://linux.die.net/man/1/mysqldump