Mysqldump

mysqldump a backup program.

Create backup

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

• mysqldump -u root -p --all-databases

Restore backup

create database DB_name;
mysql -u root -p DB_name < /path/to/file/

Related commands

• mongodump
• mariabackup (since 2017)
• mysql
• mysqldumpslow

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
• MySQL, mysqldump, mysqladmin, XtraBackup, MySQL Enterprise Backup, MyISAM, /var/log/mysql/, MySQL Workbench, Adminer, ib_logfile0, mysqld --help --verbose, MySQL versions
• XtraBackup and MyDumper
• MongoDB: mongodump, PostgreSQL: pg_dump, MariaDB: mysqldump

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