Difference between revisions of "Mysqldump"

From wikieduonline
Jump to navigation Jump to search
(4 intermediate revisions by 2 users not shown)
Line 2: Line 2:
 
<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 15: 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>[[pg_dump]]</code>
 
* <code>[[pg_dump]]</code>
Line 21: Line 22:
 
* <code>[[mysql]]</code>
 
* <code>[[mysql]]</code>
 
* <code>[[mysqldumpslow]]</code>
 
* <code>[[mysqldumpslow]]</code>
* [[snapshot]]
+
* [[Snapshot]]
 +
* <code>[[--single-transaction]]</code>
 +
 
 +
== Activities ==
 +
* Read https://stackoverflow.com/questions/104612/run-mysqldump-without-locking-tables
  
 
== See also ==
 
== See also ==
Line 28: Line 33:
 
* [[XtraBackup]] and [[MyDumper]]  
 
* [[XtraBackup]] and [[MyDumper]]  
 
* {{dbdump}}
 
* {{dbdump}}
* {{DB backup}}
+
 
  
  
 
[[Category:Databases]]
 
[[Category:Databases]]
 
[[Category:Backup]]
 
[[Category:Backup]]

Revision as of 06:25, 22 September 2022

Advertising: