S
S
sorry_i_noob2019-09-26 14:32:17
MySQL
sorry_i_noob, 2019-09-26 14:32:17

Why don't databases that were created on MySQL from another Open Server work?

I downloaded all the databases to an external hard drive (OS Panel/userdata/MySQL-5.7-x64 folder). I come to work. I put them in the appropriate folder on my working PC. I go to PhpMyAdmin - there are databases. But I want to open any table of any base - an error is produced that the table does not exist.
I launch the site - the same thing, exceptions are flying that the table does not exist. Why is that? Versions of PHP, Apache, MySQL are the same as on the other OpenServer.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
sorry_i_noob, 2019-09-27
@sorry_i_noob

It was necessary to change not only datadir, but also innodb_data_home_dir.

R
Radjah, 2019-09-26
@Radjah

Dump the database with mysqldump and deploy it to another server.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question