Difference between revisions of "Mysqldump"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
Line 1: Line 1:
<code>mysqldump</code><ref>https://linux.die.net/man/1/mysqldump</ref> client is a [[backup]] program.
+
<code>mysqldump</code><ref>https://linux.die.net/man/1/mysqldump</ref> a [[backup]] program.
  
  
Line 6: Line 6:
 
** 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]] > database_name.sql.xz</code>  
 +
 +
== Related commands ==
 +
* <code>mongodump]]</code>
  
  

Revision as of 03:34, 13 April 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 > database_name.sql.xz

Related commands

  • mongodump]]


See also

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