Get limited number of records from mysqldump

From DevOps Notebook

Revision as of 11:24, 4 December 2019 by MilosZ (talk | contribs) (Created page with "<pre> $ mysqldump --opt --where="1 limit 1000000" database_name > dump.sql </pre>")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

$ mysqldump --opt --where="1 limit 1000000" database_name > dump.sql

Retrieved from "https://devopsnotebook.com/index.php?title=Get_limited_number_of_records_from_mysqldump&oldid=84"