How to export the MySql database structure without the data just the structure

Question

I'm using a MySql database with a Java program, now I want to give the program to somebody else.

How to export the MySql database structure without the data in it, just the structure?

Answer 1

Hello @kartik,

You can do with the --no-data option with mysqldump command

mysqldump -u root -p --no-data dbname > schema.sql

Hope it works!!
Thank You!!