A
A
Anton2020-06-29 14:23:33
linux
Anton, 2020-06-29 14:23:33

How to restore mysql database from files?

There is a database (s) - copied files in ibd and frm format.
On a new server, if you create an empty database and slip files into it by file copying to the mysql folder, then the structure is visible in phpmyadmin, but the tables do not open.
I read that I need a file in the mysql root with the ibdata1 directory - I also put it in - zero sense.
The files are copied from Debian9, I'm trying to deploy to Centos7.
I don't remember what mysql version was, like 5.7
-
Once upon a time many years ago with a similar problem - replacing the ibd and frm files helped out and the databases worked. This time it didn't work.
--
There is an ancient encrypted archive in ispmanager, it is picked up on the new server and the dates of the copies are visible, but ispmanager cannot unfold them for some reason. I will try to expand the archive, restore the ancient versions of the databases, and then bring them up to date by file copying.
--
Are there any other options to restore the databases? Is there really no utility?

spoiler
5ef9cf1fd84f4665548775.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
Dmitry, 2020-06-29
@anton99zel

1) MySQL was stopped before copying?
2) does my.cnf match?
3) the rights were given to the files? (should be mysql:mysql)

S
sevic, 2021-06-12
@sevic

Same problem. Only I had everything on Windows Openserver. Winda suddenly died - is not restored. Transferred database files to another computer with Openserver - does not see the table. Tell me how to do this on Openserver, where do I specify the rights? Also can't find my.cnf file

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question