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
1 thought on “copy mysql database structure only”
Leave a Comment
You must be logged in to post a comment.
mysqldump -u root -p dbname -d > schema.sql