Difference between revisions of "Mysqldump"

From wikieduonline
Jump to navigation Jump to search
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
    • Compressing from stdin mysqldump database_name | gzip > database_name.sql.gz
    • Compressing from stdin mysqldump database_name | xz -T0 > database_name.sql.xz

Related commands

See also

  • https://linux.die.net/man/1/mysqldump
  • Advertising: