mysql workbench打开数据库_在MySQL WorkBench中打开现有数据库

最新推荐文章于 2024-09-06 13:14:04 发布

心安乃近

最新推荐文章于 2024-09-06 13:14:04 发布

阅读量1k

点赞数

文章标签： mysql workbench打开数据库

本文链接：https://blog.csdn.net/weixin_34726945/article/details/113220691

版权

I got a DB files that created in My SQL , and I want open them in My SQL WorkBench 6.1.

The files I got contains : FRM ,MYD , MYI for each table, and another file calls db.opt.

how can I import that to the workbench?

thanks.

解决方案

so first you restore the database in mysql server like explained in the linked anwser. Then you connect the workbench tool to you mysql server to open your database, note sometimes the word schema is used for "database".

to do so you need to create a database connection in workbench, i am just away from my machine. restoring the database in mysql server needs to be done before you can import / sync / reverse engineer the schema into workbench model.