Skip to main content

How to Export Only Database Structure in MySQL or MariaDB


<<Back to MySQL & MariaDB Main Page

How to Export only Database Structure Excluding data from MySQL or  MariaDB  Database


 Syntax
mysqldump --single-transaction --no-data --databases <dbname> > /stage/tmp/dump.sql

 Example
#mysqldump --single-transaction --no-data --databases testdb > /stage/tmp/testdb.sql
 

Comments

Post a Comment