Difference between revisions of "Mysqldump"
Jump to navigation
Jump to search
↑ https://linux.die.net/man/1/mysqldump
Line 8: | Line 8: | ||
*** <code>mysqldump DB_name | [[xz -T0]] > DB_name.sql.xz</code> | *** <code>mysqldump DB_name | [[xz -T0]] > DB_name.sql.xz</code> | ||
− | * <code>mysqldump -u root -p | + | * <code>mysqldump -u root -p --all-databases</code> |
== Restore backup == | == Restore backup == |
Revision as of 17:03, 28 July 2021
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/
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
Advertising: