Something really weird happened to my VPS last week. Suddenly, MySQL stopped working. My VPS has CentOS 6 and uses Parallels Plesk. After this, Parallels Plesk stopped working, and trying to start MySQL via SSH just gave me an error
Mysql daemon failed to start.
I added this
skip-grant-tables to my.cnf and I was able to start MySQL and access it... in MySQL I can see the database names. I selected the database using
use [database-name] and I can select it, but when I use
show tables it shows an empty set.
At this point I thought all the info is gone and that's it. But, outside MySQL, when I go to
/var/lib/mysql, I see folders with the database names, and inside those folders, files with the table names
At this point, all I want is to be able to create a dump file of a certain database. Is there a way to make MySQL use these files so I can recover that data and be able to export it?