7 replies
hi guys,
One of mysql database was opened and showed me an error: Table is crashed and last repair failed. I don't know how to get back mysql database, any suggestions, please... I need to a method for mysql recovery.
#database #mysql
  • Profile picture of the author Weblin
    Try running repair table <table_name>; via ssh. You can use also repair the table via a GUI if you have access to PHPmyadmin.

    It should recover your failed table in the database.
    Signature
    www.HandleMySite.com handles your WordPress site by doing all of the maintenance and technical work for you. Making backups, managing updates, maintenance, performance, security, SEO, etc.
    {{ DiscussionBoard.errors[10937433].message }}
    • Profile picture of the author undae095
      Originally Posted by Weblin View Post

      Try running repair table <table_name>; via ssh. You can use also repair the table via a GUI if you have access to PHPmyadmin.

      It should recover your failed table in the database.
      Thank you a lot dude, it almost helped me. It restored the database more than 70%.
      {{ DiscussionBoard.errors[10943570].message }}
      • Profile picture of the author Weblin
        Originally Posted by undae095 View Post

        Thank you a lot dude, it almost helped me. It restored the database more than 70%.
        Good to know that. I wish you luck in restoring the database further.
        Signature
        www.HandleMySite.com handles your WordPress site by doing all of the maintenance and technical work for you. Making backups, managing updates, maintenance, performance, security, SEO, etc.
        {{ DiscussionBoard.errors[10943580].message }}
  • Profile picture of the author Pablo Montanas
    Or run some SQL Recovery Software. I don't have a link but you gotta search for it.
    {{ DiscussionBoard.errors[10945051].message }}
  • Profile picture of the author Pilchardp
    Originally Posted by undae095 View Post

    hi guys,
    One of mysql database was opened and showed me an error: Table is crashed and last repair failed. I don't know how to get back mysql database, any suggestions, please... I need to a method for mysql recovery.
    One of the popular and effective methods below, in case it can't help, then mysql database is seriously damaged, I would advise you to apply Recovery Toolbox for MySQL, its features and demo see on https://mysql.recoverytoolbox.com/ it was created for high complicated cases, when other solutions don't work.
    {{ DiscussionBoard.errors[10951470].message }}
  • Profile picture of the author dilek101
    you should check your logs for any errors, as a last resort
    use mysqldump to dump all of it and save it and then just reinstall mysql and
    {{ DiscussionBoard.errors[10952016].message }}
  • Profile picture of the author undae095
    Guys, I'm very thankful to you, I solved my trouble
    {{ DiscussionBoard.errors[10954651].message }}

Trending Topics