Mysqldump

mysqldump a backup program.

mysqldump --help
mysqldump --single-transaction
mysqldump --skip-lock-tables

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

• mysqldump -u root -ppassword --flush-logs --delete-master-logs --all-databases > full-backup.sql

Restore backup

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

Related

• mongodump
• pg_dump
• mariabackup (since 2017)
• mysql
• mysqldumpslow
• Snapshot
• --single-transaction

set -o pipefail
mysqldump [...] | restic -r /srv/restic-repo backup --stdin

Activities

• Read https://stackoverflow.com/questions/104612/run-mysqldump-without-locking-tables

See also

• mysqldump [ --single-transaction ]
• 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