mysql dump file to schemda code example

Example 1: get only structure database mysql

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

Example 2: mysql dump structure only

mysqldump -d -u someuser -p mydatabase products categories users