MySql export schema without data

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

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

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

Answer 2

In case you are using IntelliJ you can enable the Database view (View -> Tools Window -> Database)

Inside that view connect to your database. Then you can rightclick the database and select "Copy DDL". Other IDEs may offer a similar function.

Answer 3

Dumping without using output.

mysqldump --no-data <database name> --result-file=schema.sql

Answer 4

Yes, you can use mysqldump with the --no-data option:

mysqldump -u user -h localhost --no-data -p database > database.sql

Answer 5

To get an individual table's creation script:
- select all the table (with shift key)
- just right click on the table name and click Copy to Clipboard > Create Statement.

Answer 6

You can take using the following method

mysqldump -d <database name> > <filename.sql> // -d : without data

Hope it will helps you