Missing database

[expired user #11218]'s profile image [expired user #11218] posted 6 years ago in General Permalink

Hello everyone,

I'm using HeidiSQL and I've got a problem with one of my MySQL database. Maybe the issue is not coming from Heidi, but I'm asking anyway. The database has disappeared overnight and I cannot find it either in my HeidiSQL (unknown database) or in PhpMyAdmin.

In C:\wamp\bin\mysql\mysql5.7.14\data there's no folder for my missing database. However, I've found one folder with the name of my database here: C:\ProgramData\MySQL\MySQL Server 5.7\Data\base_memoire. In this folder there're two files for each of my tables, one .frm and one .ibd, plus one file named db.opt.

Does anyone know what's the cause of the problem, and how would it be possible to retrieve these tables?

Thanks a lot!

Please login to leave a reply, or register at first.