locked
Unable to open mysql database file - corrupted RRS feed

  • Question

  • User612202487 posted

    Hi all, My file with data from My SQL server was corrupted, and I have no backup of the database. But as it seems that there is no problem in the system log file . Can anyone please help in recovering data from corrupt .the sql file? Are there any methods or steps to recover the data file with the system log?

    Friday, August 11, 2017 12:39 PM

Answers

  • User-718146471 posted

    As I said, it might be unrecoverable unfortunately. When any database file goes kaflewie the likelihood of restoring the file is very low.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, August 21, 2017 4:10 PM

All replies

  • User-718146471 posted

    I hate to be the voice of gloom and doom but the likelihood of recovering the data is going to prove very difficult if not impossible. Try opening that database file in Notepad++ and see if you can even read anything there. Again, not exactly sure how lucky you will be at recovering the data; I hope someone here has some good news or a way to recover your MySQL DB. If you are hosted remotely, I would contact the host and ask if they may have a good backup of the MySQL DB in the database prior to the point of corruption.

    Friday, August 11, 2017 7:18 PM
  • User612202487 posted

    Hello , thanks for the help , now I will try something to take your advice, I was advised to mysql recovery

    Sunday, August 20, 2017 9:00 AM
  • User612202487 posted

    Tried to restore different backups , but to no avail(((

    Sunday, August 20, 2017 9:07 AM
  • User-718146471 posted

    As I said, it might be unrecoverable unfortunately. When any database file goes kaflewie the likelihood of restoring the file is very low.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, August 21, 2017 4:10 PM