copy mysql database structure only
MySql export schema without data
- Login to DB server
- Run the below command to take backup of schema of database without data.
# mysqldump -u root –p -d olddb > backup.sql
OR
# mysqldump -u root -p –no-data dbname > schema.sql
mysqldump -u root -p dbname -d > schema.sql