Using mysqldump

From Littledamien Wiki
Revision as of 15:31, 4 March 2013 by Video8 (talk | contribs) (Created page with "== Overview == Quick references for `mysqldump` tasks. == Common tasks == === Dump everything from a database === Includes both structure and data. <syntaxhighlight lang=...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Overview

Quick references for mysqldump tasks.

Common tasks

Dump everything from a database

Includes both structure and data. 

$ mysqldump --user[=username] --password[=password] database [tables]

Add -t or --no-create-info option to dump only data.

Add -d or --no-data option to dump only table structure.

Retrieved from "https://wiki.dbarchowsky.com/index.php?title=Using_mysqldump&oldid=439"