Difference between revisions of "Mysqldump"
Jump to navigation
Jump to search
↑ https://linux.die.net/man/1/mysqldump
Line 21: | Line 21: | ||
* <code>[[mysql]]</code> | * <code>[[mysql]]</code> | ||
* <code>[[mysqldumpslow]]</code> | * <code>[[mysqldumpslow]]</code> | ||
+ | * [[snapshot]] | ||
== See also == | == See also == |
Revision as of 18:52, 20 May 2022
mysqldump
[1] a backup program.
Create backup
mysqldump DB_name > DB_name.sql
mysqldump -u root -p --all-databases
Restore backup
create database DB_name; mysql -u root -p DB_name < /path/to/file/DB_name.sql
Related commands
mongodump
pg_dump
mariabackup
(since 2017)mysql
mysqldumpslow
- snapshot
See also
- 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: