Difference between revisions of "Mysqldump"
Jump to navigation
Jump to search
↑ https://linux.die.net/man/1/mysqldump
(→Usage) |
(→Usage) |
||
Line 2: | Line 2: | ||
− | == | + | == Create backup == |
* <code>mysqldump DB_name > DB_name.sql</code> | * <code>mysqldump DB_name > DB_name.sql</code> | ||
** Compressing from <code>[[stdin]]</code> | ** Compressing from <code>[[stdin]]</code> | ||
Line 9: | Line 9: | ||
* <code>mysqldump -u root -p –all-databases</code> | * <code>mysqldump -u root -p –all-databases</code> | ||
+ | |||
+ | == Restore backup == | ||
+ | [[create database]] DB_name; | ||
== Related commands == | == Related commands == |
Revision as of 17:02, 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;
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: