Difference between revisions of "Mysqldump"
Jump to navigation
Jump to search
↑ https://linux.die.net/man/1/mysqldump
| (4 intermediate revisions by 2 users not shown) | |||
| Line 3: | Line 3: | ||
[[mysqldump --help]] | [[mysqldump --help]] | ||
| + | [[mysqldump --single-transaction]] | ||
| + | [[mysqldump --skip-lock-tables]] | ||
== Create backup == | == Create backup == | ||
| Line 12: | Line 14: | ||
* <code>mysqldump -u root -p --all-databases</code> | * <code>mysqldump -u root -p --all-databases</code> | ||
| − | * <code>mysqldump -u root -ppassword --flush-logs --delete-master-logs --all-databases > full-backup.sql</code> | + | * <code>mysqldump -u root -ppassword [[--flush-logs]] [[--delete-master-logs]] [[--all-databases]] > full-backup.sql</code> |
== Restore backup == | == Restore backup == | ||
| Line 26: | Line 28: | ||
* [[Snapshot]] | * [[Snapshot]] | ||
* <code>[[--single-transaction]]</code> | * <code>[[--single-transaction]]</code> | ||
| + | |||
| + | [[set -o pipefail]] | ||
| + | mysqldump [...] | restic -r /srv/restic-repo backup --stdin | ||
== Activities == | == Activities == | ||
| Line 31: | Line 36: | ||
== See also == | == See also == | ||
| + | * {{mysqldump}} | ||
* {{MariaDB}} | * {{MariaDB}} | ||
* {{MySQL}} | * {{MySQL}} | ||
Latest revision as of 06:34, 9 June 2024
mysqldump[1] a backup program.
mysqldump --help mysqldump --single-transaction mysqldump --skip-lock-tables
Create backup[edit]
mysqldump DB_name > DB_name.sql
mysqldump -u root -p --all-databases
mysqldump -u root -ppassword --flush-logs --delete-master-logs --all-databases > full-backup.sql
Restore backup[edit]
create database DB_name; mysql -u root -p DB_name < /path/to/file/DB_name.sql
Related[edit]
mongodumppg_dumpmariabackup(since 2017)mysqlmysqldumpslow- Snapshot
--single-transaction
set -o pipefail mysqldump [...] | restic -r /srv/restic-repo backup --stdin
Activities[edit]
See also[edit]
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, /var/log/mysql/mariadb-slow.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,/etc/mysql/ - 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
Advertising:
