在MySQL WorkBench中打开现有数据库 [英] Open Existing DB in MySQL WorkBench

问题描述

我有一个在My SQL中创建的数据库文件，我想在My SQL WorkBench 6.1中打开它们. 我得到的文件包含:每个表的FRM，MYD，MYI，另一个文件名为db.opt. 如何将其导入工作台?

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?

谢谢.

推荐答案

，因此首先您要像链接anwser中所述在mysql服务器中还原数据库.然后，将工作台工具连接到mysql服务器以打开数据库，请注意，有时将架构"一词用于数据库".

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".

要这样做，您需要在工作台中创建数据库连接，而我离我的机器很远.必须先在mysql服务器中恢复数据库，然后才能将架构导入/同步/反向工程到工作台模型中.

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.

这篇关于在MySQL WorkBench中打开现有数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！