dbTalk Databases Forums  

Export the database tables to schema.

comp.databases.mysql comp.databases.mysql


Discuss Export the database tables to schema. in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mr. X.
 
Posts: n/a

Default Export the database tables to schema. - 03-05-2010 , 01:50 PM






How can I in workbrench export the whole database schema (create table) to a
file ?

Thanks

Reply With Quote
  #2  
Old   
Brian Cryer
 
Posts: n/a

Default Re: Export the database tables to schema. - 03-08-2010 , 03:28 AM






"Mr. X." <nospam.mry (AT) gmail (DOT) com> wrote

Quote:
How can I in workbrench export the whole database schema (create table) to
a file ?
Sorry, don't know. But I would ask whether that's the right tool for the
job. You can use mysqldump to dump the schema to a file - I know its
normally used to generate backups (so including data) but there is a switch
to omit the data which should leave you with a script to create the database
schema.

HTH.
--
Brian Cryer
www.cryer.co.uk/brian

Reply With Quote
  #3  
Old   
Erick T. Barkhuis
 
Posts: n/a

Default Re: Export the database tables to schema. - 03-08-2010 , 03:39 AM



Mr. X.:

Quote:
How can I in workbrench export the whole database schema (create
table) to a file ?
crtl+shft+G
[Or use File > Export > Forward engineer Create Script]


--
Erick

Reply With Quote
  #4  
Old   
Mr. X.
 
Posts: n/a

Default Re: Export the database tables to schema. - 03-08-2010 , 02:24 PM



It does nothing.
Should I point by mouse on some elements ?

Thanks

"Erick T. Barkhuis" <erick.use-net (AT) ardane (DOT) c.o.m> wrote

Quote:
Mr. X.:

How can I in workbrench export the whole database schema (create
table) to a file ?

crtl+shft+G
[Or use File > Export > Forward engineer Create Script]


--
Erick

Reply With Quote
  #5  
Old   
Erick T. Barkhuis
 
Posts: n/a

Default Re: Export the database tables to schema. - 03-09-2010 , 12:51 AM



Mr. X.:

[Top post repaired; please, refrain from that]

Quote:
"Erick T. Barkhuis" <erick.use-net (AT) ardane (DOT) c.o.m> wrote in message
news:7vjuuaF472U1 (AT) mid (DOT) individual.net...
Mr. X.:

How can I in workbrench export the whole database schema (create
table) to a file ?

crtl+shft+G
[Or use File > Export > Forward engineer Create Script]

It does nothing.
Should I point by mouse on some elements ?
If you open a database and then use that application function, it
should work. What does "it does nothing" mean? Do you get an error
message? An empty output file? Something else?

And what version of Workbench are you using?
[We _are_ talking about "MySQL Workbench", aren't we?]


--
Erick

Reply With Quote
  #6  
Old   
Mr. X.
 
Posts: n/a

Default Re: Export the database tables to schema. - 03-12-2010 , 06:05 AM



MySql WorkBench 5.2.16 OSS Beta.
I have installed it on Windows-7.

It does nothing (I see the CTRL-SHIFT-G) :
I click on it on the menu, but no window commet, no error commet, and the
menu isn't close.
It looks like a bug in WorkBench.

Thanks

"Erick T. Barkhuis" <erick.use-net (AT) ardane (DOT) c.o.m> wrote

Quote:
Mr. X.:

[Top post repaired; please, refrain from that]


"Erick T. Barkhuis" <erick.use-net (AT) ardane (DOT) c.o.m> wrote in message
news:7vjuuaF472U1 (AT) mid (DOT) individual.net...
Mr. X.:

How can I in workbrench export the whole database schema (create
table) to a file ?

crtl+shft+G
[Or use File > Export > Forward engineer Create Script]

It does nothing.
Should I point by mouse on some elements ?

If you open a database and then use that application function, it
should work. What does "it does nothing" mean? Do you get an error
message? An empty output file? Something else?

And what version of Workbench are you using?
[We _are_ talking about "MySQL Workbench", aren't we?]


--
Erick

Reply With Quote
  #7  
Old   
Erick T. Barkhuis
 
Posts: n/a

Default Re: Export the database tables to schema. - 03-12-2010 , 06:12 AM



Mr. X.:

[Top post fixed]

Quote:
"Erick T. Barkhuis" <erick.use-net (AT) ardane (DOT) c.o.m> wrote in message
news:7vm9fqFgu1U1 (AT) mid (DOT) individual.net...
Mr. X.:

[Top post repaired; please, refrain from that]
Oh, please!!


Quote:

"Erick T. Barkhuis" <erick.use-net (AT) ardane (DOT) c.o.m> wrote in message
news:7vjuuaF472U1 (AT) mid (DOT) individual.net...
Mr. X.:

How can I in workbrench export the whole database schema
(create table) to a file ?

crtl+shft+G
[Or use File > Export > Forward engineer Create Script]

It does nothing.

MySql WorkBench 5.2.16 OSS Beta.
I have installed it on Windows-7.
Well, I'm sorry, but I can't be of any help, then.
I use 5.1.16 OSS (final) on XP and W7, and that version works as
expected.


--
Erick

Reply With Quote
  #8  
Old   
Mr. X.
 
Posts: n/a

Default Re: Export the database tables to schema. - 04-04-2010 , 06:49 PM



It is disabled.
I am on database -> query database (on top menu)
Then stands on the left on one of my schema (the node under it is table).
Do : file -> export

Reply With Quote
  #9  
Old   
Mr. X.
 
Posts: n/a

Default Re: Export the database tables to schema. - 04-04-2010 , 06:53 PM



The choice is disabled.

I am on database -> query database (on top menu)
Then stands on the left on one of my schema (the node under it is table).
Do : file -> export
and then I see that every choice is at a disable state :
Forward engineer create sql script
Forward engineer create alter script
Synchronized with sql script
etc ...

Thanks

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.