1

How can I only dump the full db schema without any data. Including tables, views, functions, procedures and all that stuff. I have it with data, meaning it's scattered throughout the >2GB dump.

Improve this question
1
  • Read through mysqldump --help Commented May 21, 2019 at 5:04

1 Answer 1

Reset to default
2

Use the command line switch --no-data (http://www.manpagez.com/man/1/mysqldump/)

mysqldump --all-databases --no-data > all_databases.sql
Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thanks, I knew that option existed but forgot how it was called. Have a great day!

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.