Open Existing DB in MySQL WorkBench

Question

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? enter image description here

thanks.

check the awnser to this question: stackoverflow.com/questions/879176/… — M.Scherzer
– M.Scherzer, Commented Apr 22, 2014 at 22:07
Hi how can I find my path to the DB directory? I look here : C:\Program Files\MySQL\MySQL Server 5.5\data\mysql There are files (MYD,MYI,FRM) but not of my schema in the workbench. — user2097810
– user2097810, Commented Apr 22, 2014 at 22:11

M.Scherzer · Accepted Answer · 2014-04-22 22:19:59Z

5

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.

answered Apr 22, 2014 at 22:19

M.Scherzer

9207 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Open Existing DB in MySQL WorkBench

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related