Difference between revisions of "Mysqldump"
Jump to navigation
Jump to search
↑ https://linux.die.net/man/1/mysqldump
Tags: Mobile web edit, Mobile edit |
Tags: Mobile web edit, Mobile edit |
||
Line 3: | Line 3: | ||
== Usage == | == Usage == | ||
− | * <code>mysqldump | + | * <code>mysqldump DB_name > DB_name.sql</code> |
− | ** Compressing from <code>[[stdin]]</code> <code>mysqldump | + | ** Compressing from <code>[[stdin]]</code> |
− | ** | + | *** <code>mysqldump DB_name | [[gzip]] > DB_name.sql.gz</code> |
+ | *** <code>mysqldump DB_name | [[xz -T0]] > DB_name.sql.xz</code> | ||
== Related commands == | == Related commands == |
Revision as of 14:06, 23 August 2020
mysqldump
[1] a backup program.
Usage
mysqldump DB_name > DB_name.sql
Related commands
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/
- XtraBackup and MyDumper
- MongoDB:
mongodump
, PostgreSQL:pg_dump
, MariaDB: mysqldump
Advertising: