Advertisement: Over 100,000 Jobs Worldwide. Click here to find one for you.

MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors
Send This Page to Friend
Enter Friend's Email
Enter Your Email
http://www.kareerlinks.com/jobs/skill/MySQL
 
Home / Data Back Up / Export Data / Question No: 82

How to take dump of database without its data?

I need database structure only so I want to take dump of my database dump without its data. Is there any way to to take dump of the database without its data?

Answer No: 82

MySQL provides mysqldump utility to take dump of databases with several options. You can use mysqldump utility with --no-data option. Take an example to take dump of the database structure:

shell> mysqldump --password=root --user=root test > test_dump.sql --no-data
Comments
Add Comments
Found a bug? Or do you have a better solution for this? Feel free to leave a message:
Leave a comment
Your Name: Your Email Address (optional):
Comment:

Related MySQL FAQs to the Above FAQ

How-to-use-SELECT-INTO-OUTFILE-statement-to-export-data How to use SELECT INTO OUTFILE statement to export data?

How-to-export-table-data-to-text-file-with-SELECT-INTO-OUTFILE-statement How to export table data to text file with SELECT INTO OUTFILE statement?

How-to-export-table-data-to-Microsoft-Excel-with-SELECT-INTO-OUTFILE-statement How to export table data to Microsoft Excel with SELECT INTO OUTFILE statement?

How-to-use-mysqldump-to-export-data How to use mysqldump to export data?

How-to-take-dump-of-the-database How to take dump of the database?


© Copyrights 2007 - 2008 by mysqlfaqs.net
The site is owned and operated by Mr. Javed Bhatti - Pakistan.		Site Map | Bookmark Us | Kareer Links | Contact Us