?
Solved

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

Posted on 2008-06-13
4
Medium Priority
?
622 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 25

Accepted Solution

by:
Tomas Helgi Johannsson earned 2000 total points
ID: 21778334
      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
ID: 31466910
Much Thanks
0
 

Author Comment

by:Prysson
ID: 21778764
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 25

Expert Comment

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

Regards,
   Tomas Helgi
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

649 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