Table structure to a file
This is a discussion on Table structure to a file within the MySQL forums, part of the Database category; In MySQL How do I dump only the table structure to a file? Matrix_2006...
-
12-29-2006, 07:47 AM #1
- Join Date
- Jan 2006
- Answers
- 5
Table structure to a file
In MySQL How do I dump only the table structure to a file?
Matrix_2006
-
You can use the option -d with mysqldump to dump only the table structure to a file.
The syntax is as below:
mysqldump -d -h localhost -u root -pmypassword databasename > dumpfile.sql
Reply With QuoteConnect
Exforsys e-Newsletter
Enhance Technical and Soft Skills every week, get our Job Interview Questions and Answers eBook free when you subscribe.
Subscribe and Get Free Bonus PDF Book
