Prysson
asked on
How do I create a DDL Script to capture the schema of an existing Database
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
This is my statement
mysqldump --no-data vinwin_base
is there some part I am missing?
This is one of many command line tools provided with mysql.
Regards,
Tomas Helgi
Regards,
Tomas Helgi
ASKER