Difference between revisions of "Mysqldump"

Revision as of 14:06, 23 August 2020

mysqldump^[1] a backup program.

mysqldump DB_name > DB_name.sql
- Compressing from stdin
  - mysqldump DB_name | gzip > DB_name.sql.gz
  - mysqldump DB_name | xz -T0 > DB_name.sql.xz

@@ Line 3: / Line 3: @@
 == Usage ==
-* <code>mysqldump database_name > database_name.sql</code>
+* <code>mysqldump DB_name > DB_name.sql</code>
-** Compressing from <code>[[stdin]]</code> <code>mysqldump database_name | [[gzip]] > database_name.sql.gz</code>
+** Compressing from <code>[[stdin]]</code>
-** Compressing from <code>[[stdin]]</code> <code>mysqldump database_name | [[xz -T0]] > database_name.sql.xz</code>
+*** <code>mysqldump DB_name | [[gzip]] > DB_name.sql.gz</code>
+*** <code>mysqldump DB_name | [[xz -T0]] > DB_name.sql.xz</code>
 == Related commands ==