mysql workbench的特长是创建表结构的,然后在结构图中,圈圈点点,很容易就利用可视化方式把数据库建好,然后再导入到数据库服务器中,这种办法很效率。但是有时我们有一个需求,事先没有建表结构模型,而是利用别的数据库软件建的数据库,并且我们还想利用workbench的表结构模型在上面修改,此时,如何所已有的数据库导出为模型表结构就是焦点了!
mysql workbench如何把已有的数据库导出ER模型
2018-2-28更新
Mysql workbench “Too many objects are selected for auto placement. Select fewer elements to create the EER diagram.”怎么解决? Workbench emits that "Resource Warning" error and then deselects the "Place imported objects on a diagram" option for you. Execute it again (click "Execute") without that option to execute the Reverse Engineering wizard. Then, create a new EER diagram, select all tables (objects) using the "Catalog" tab on the left pane, and then drag them onto the EER diagram canvas. This will take a few minutes or so to execute. When finished, optionally select "Autolayout" from the "Arrange" navigation menu and then wait another few minutes.I just tested this with 2000 tables and it works.
Do you know how to auto arrange tables? Menu/Arrange/Autolayout arranges it, but anyway there are many tables located over other ones. – Renat Gatin Sep 10 '15 at 0:21
@Philip Olson, Yes its worked for me, but tables are located over other ones , suggest me how to arrange line by rows. – Rajkumar .E Mar 17 '17 at 5:37
转自:https://stackoverflow.com/questions/27700967/mysql-workbench-too-many-objects-are-selected-for-auto-placement-select-fewer
简要总结:
mysql workbench支持逆向工程建模,具体操作如下:
Menu
Database->Reverse Engineer...
弹出Reverse Engineer Database对话框
Connection Options
->next
Connection to DBMS
->next
Select Schemas
选择要逆向的数据库
Select Objects
->next
Reverse Engineer
->Execute
Results
->Finish
相关文章
- 细说MySQL数据库操作
- VS+MySQL——1. 安装MySQL数据库详细步骤
- linux系统上Mysql数据库导入导出操作
- 【数据库开发】如何创建MySQL数据库连接池(一个基于libmysql的MySQL数据库连接池示例(C/C++版))
- mysql-数据类型与java数据类型转化工具类
- mysql数据库默认存放位置修改
- mysql 行转列 多行转一行
- 数据库初识--从MySQL 出发
- 使用MySQL,SQL_MODE有哪些坑,你知道么?
- MySQL分区表的管理~1
- MySQL数据库范式
- MySQL 数据库误删除后的数据恢复操作说明
- [数据库]MySQL解决:MySQLNonTransientConnectionException: Could not create connection to database server.【待完善】
- [数据库]MySQL之SQL查询
- 数据库:Mysql中“select ... for update”排他锁分析
- MySQL数据库从windows迁移到linux
- Mysql 一次性备份导出/导入恢复所有数据库
- 用(*.frm *.MYD *.MYI)文件恢复MySql数据库
- mysql必知必会(一、数据库基础知识)
- Mysql读写分离与主从数据库设置方案
- [Sqoop]将Hive数据表导出到Mysql
- mysql:索引
- mysql 数据库替换字段文字
- Egg 项目怎么连接 MySQL 实现增删改查接口?
- Mysql——查看数据库,表占用磁盘大小
- MySql数据库连接超时处理
- 【mysql】Linux 启动 / 停止 / 重启 Mysql 数据库的方法