S
S
someserj2016-04-04 23:16:06
MySQL
someserj, 2016-04-04 23:16:06

How to restore SQL database with .frm, .MYI, .MYD, .opt files?

here are the rest of the files from the database. at least restore the structure and relationships between tables, I'm not talking about the data itself
MGg1gFG.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
T
ThunderCat, 2016-04-04
@ThunderCat

there is such suffering, but in general Google can do a lot of gitik (c)

A
Anton B, 2016-04-05
@bigton

Judging by the screenshot, you have a MyISAM engine. In this case, each table is stored in 3 files:
.frm is the structure of the table
.MYD - data
.MYI - indexes
In principle, to restore such a database, it is enough to copy these files to the database folder and restart mysql.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question