Solved

How do I create a DDL Script to capture the schema of an existing Database

Posted on 2008-06-13
4
615 Views
Last Modified: 2012-05-05
Im new to MySQL and Im trying to get my bearing on the basic tools.

Trying to generate a DDL to import into the workbench (don't know why the workbench cant just connect to a database and generater one itself...seems like a fairly obvious usage)

Be that as it may I cant seem to figure out how to accomplish this or at least there doesnt seem to be a basic gui option to generate it so I assum I probably have to run some kind of command...

What would the correct command be..or am I wrong and is there an easy way in the basic tool sets to generate this DDL script.

I am using the 5.0 my sql tools
0
Comment
Question by:Prysson
  • 2
  • 2
4 Comments
 
LVL 24

Accepted Solution

by:
Tomas Helgi Johannsson earned 500 total points
Comment Utility
      Hi!

Use mysqldump with the option --no-data see following
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
That produces the DDL of your database.

Regards,
   Tomas Helgi
0
 

Author Closing Comment

by:Prysson
Comment Utility
Much Thanks
0
 

Author Comment

by:Prysson
Comment Utility
One question...I am doing this on a windows box..my assumption was that I should be able to just do this in the query browser...but I get syntax errors...

This is my statement

mysqldump --no-data vinwin_base

is there some part I am missing?
0
 
LVL 24

Expert Comment

by:Tomas Helgi Johannsson
Comment Utility
This is one of many  command line tools provided with mysql.

Regards,
   Tomas Helgi
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Creating and Managing Databases with phpMyAdmin in cPanel.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now