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 5: | Line 5: | ||
* <code>mysqldump database_name > database_name.sql</code> | * <code>mysqldump database_name > database_name.sql</code> | ||
** Compressing from <code>[[stdin]]</code> <code>mysqldump database_name | [[gzip]] > database_name.sql.gz</code> | ** Compressing from <code>[[stdin]]</code> <code>mysqldump database_name | [[gzip]] > database_name.sql.gz</code> | ||
− | ** Compressing from <code>[[stdin]]</code> <code>mysqldump database_name | [[xz]] > database_name.sql.xz</code> | + | ** Compressing from <code>[[stdin]]</code> <code>mysqldump database_name | [[xz -T0]] > database_name.sql.xz</code> |
== Related commands == | == Related commands == |
Revision as of 14:04, 23 August 2020
mysqldump
[1] a backup program.
Usage
mysqldump database_name > database_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
, 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 - XtraBackup and MyDumper
- MongoDB:
mongodump
, PostgreSQL:pg_dump
, MariaDB: mysqldump
Advertising: