Search Marketing

   
   

How to Export Table Schema without Data in MySQL

Mon Apr 05, 2010 1:34 pm
<<     >>
Comments: 0 Views: 268

Problem: You only need the database schema information without all the insert statements.

Solution: You can use the following code to export all the table creation information without other data being included in the file.

mysqldump -u -p --no-data db_name > db_name_nodata.sql

The key option is the "--no-data" trigger in the dump statement.



Comments
Name:
*
URL: http: (ex. cnn.com)
Comment:
*
Number:
Math (10 + 5)
* required
SubCategories
Books

© 2017 Christonium LLC

Christonium.com
|
Terms of Use
|
Privacy
ccc