mysql database

by 7 replies
8
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.
#programming #database #mysql
  • 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.
    • [1] reply
    • Thank you a lot dude, it almost helped me. It restored the database more than 70%.
      • [1] reply
  • Or run some SQL Recovery Software. I don't have a link but you gotta search for it.
  • 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.
  • 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
  • Guys, I'm very thankful to you, I solved my trouble
Join the discussion

Next Topics on Trending Feed

  • 8

    mysql database

    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.