Skip to content

Instantly share code, notes, and snippets.

@ricardoaugusto

ricardoaugusto/mysqldump-10rows.sql

Created May 19, 2020 15:08
Show Gist options
  • Save ricardoaugusto/bdf8f20cf2024a6ad952b9b29d898fb3 to your computer and use it in GitHub Desktop.
Save ricardoaugusto/bdf8f20cf2024a6ad952b9b29d898fb3 to your computer and use it in GitHub Desktop.
Download ZIP
Export the schema and 10 rows of data from all tables of a DB
Raw
mysqldump-10rows.sql
mysqldump --opt --where="1 limit 10" [DATABASE] > dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment