Difference between revisions of "Mysqldump"

From wikieduonline
Jump to navigation Jump to search
(8 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.
 
<code>mysqldump</code><ref>https://linux.die.net/man/1/mysqldump</ref> a [[backup]] program.
  
 +
[[mysqldump --help]]
  
 
== Create backup ==
 
== Create backup ==
Line 14: Line 16:
 
  mysql -u root -p DB_name < /path/to/file/DB_name.sql
 
  mysql -u root -p DB_name < /path/to/file/DB_name.sql
  
== Related commands ==
+
== Related ==
 
* <code>[[mongodump]]</code>
 
* <code>[[mongodump]]</code>
* <code>[[pgdump]]</code>
+
* <code>[[pg_dump]]</code>
 
* <code>[[mariabackup]]</code> (since 2017)
 
* <code>[[mariabackup]]</code> (since 2017)
 
* <code>[[mysql]]</code>
 
* <code>[[mysql]]</code>
 
* <code>[[mysqldumpslow]]</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 ==
Line 26: Line 33:
 
* [[XtraBackup]] and [[MyDumper]]  
 
* [[XtraBackup]] and [[MyDumper]]  
 
* {{dbdump}}
 
* {{dbdump}}
 +
  
  
 
[[Category:Databases]]
 
[[Category:Databases]]
 
[[Category:Backup]]
 
[[Category:Backup]]

Revision as of 06:25, 22 September 2022

Advertising: