CODEWITHSUNDEEP
mysqlmysql-workbench
amitchhajer
amitchhajer

Reputation: 12830

Using mysql workbench reverse enginerring command line

I have a live database and i was trying to generate model/ E-R diagram for database visualization.

Opened command line help but can't really find the way to do the same.

I don't have a UI support where my sql database exist.

Can i generate the E-R diagram or model from it using command line options?

Upvotes: 1

Views: 481

Answers (2)

Sergio
Sergio

Reputation: 4567

You can generate the EER diagrams from MySQL Workbench main screen. You don't have to have a GUI in your server since you can connect to it from the PC running Workbench. All you have to do is set up a connection to your server in MySQL Workbench.

Upvotes: 1

pQd
pQd

Reputation: 126

you cannot, but following commands should give you an idea what's inside:

  • show databases;
  • use databaseName; show tables;
  • show create table tableName;

Upvotes: 1

Related Questions