0

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 MYD.crypt or MYI.Crypt.

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?

Thank you.

Improve this question
1
  • MYD and MYI are for MyISAM tables. Did you "encrypt" the database?
    – Rick James
    Jun 8, 2017 at 22:25

1 Answer 1

Reset to default
0

There is more information need to troubleshooting.

  1. What is the error logs for Mysql daemon failed to start for normal start?

    [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

  2. What is the engine for MYD/MYI?

  3. Do you have previous backups or replication site?
Improve this answer
1
  • Comments are not for extended discussion; this conversation has been moved to chat.
    – Paul White ♦
    Aug 29, 2017 at 9:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.