MySql export schema without data
You can do with the --no-data
option with mysqldump command
mysqldump -h yourhostnameorIP -u root -p --no-data dbname > schema.sql
Yes, you can use mysqldump
with the --no-data
option:
mysqldump -u user -h localhost --no-data -p database > database.sql