Difference between revisions of "Mysqldump"

From wikieduonline
Jump to navigation Jump to search
(27 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
{{lc}}
 +
<code>mysqldump</code><ref>https://linux.die.net/man/1/mysqldump</ref> a [[backup]] program.
  
 +
[[mysqldump --help]]
  
 +
== Create backup ==
 +
* <code>mysqldump DB_name > DB_name.sql</code>
 +
** 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>
  
== Usage ==
+
* <code>mysqldump -u root -p --all-databases</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 | [[xz]] > database_name.sql.xz</code>  
 
  
 +
== Restore backup ==
 +
[[create database]] DB_name;
 +
mysql -u root -p DB_name < /path/to/file/DB_name.sql
 +
 +
== Related ==
 +
* <code>[[mongodump]]</code>
 +
* <code>[[pg_dump]]</code>
 +
* <code>[[mariabackup]]</code> (since 2017)
 +
* <code>[[mysql]]</code>
 +
* <code>[[mysqldumpslow]]</code>
 +
* [[Snapshot]]
 +
* <code>[[--single-transaction]]</code>
 +
 +
== Activities ==
 +
* Read https://stackoverflow.com/questions/104612/run-mysqldump-without-locking-tables
  
 
== See also ==
 
== See also ==
 
* {{MariaDB}}
 
* {{MariaDB}}
 +
* {{MySQL}}
 
* [[XtraBackup]] and [[MyDumper]]  
 
* [[XtraBackup]] and [[MyDumper]]  
* [[MongoDB]]: <code>[[mongodump]]</code>, [[PostgreSQL]]: <code>[[pg_dump]]</code>
+
* {{dbdump}}
 +
 
  
  
 
[[Category:Databases]]
 
[[Category:Databases]]
 
[[Category:Backup]]
 
[[Category:Backup]]

Revision as of 06:25, 22 September 2022

Advertising: