How to Repair MySQL Database Without the Backup Plan?

  • Replies:2
  • OpenNot stickiedUnanswered
  2
annibraun
  • Forum posts: 3

Jul 29, 2020, 9:12:08 AM via Website

Suddenly MYSQL database is corrupt due to unexpected server shutdown that caused the database to go bad. Queries that worked before suddenly stopped working and overall the database is not responding anymore. I also forgot to take a database backup.
To repair the MYSQL database, I have tried through cPanel and phpMyAdmin. But still, the database not recovered.

Reply
  2
Victoriya Luna
  • Forum posts: 2

Jul 29, 2020, 1:49:34 PM via Website

Last week, I had encountered this same error. Then, I solved this error by creating using “Mysqldump Utility”. Using mysqldump, you can backup your database and restore it on a remote database simultaneously. You can restore the entire database using the ‘mysql’ command.
If you want, you can read this post to explore other possible reasons & solutions for this issue.
Reference- www.stellarinfo.com/blog/repair-mysql-database-without-backup-plan/

— modified on Jul 29, 2020, 1:50:22 PM

Helpful?
Reply
  2
HeatherVaV
  • Forum posts: 10

Aug 6, 2020, 4:55:33 PM via Website

Thanks for sharing

Helpful?
Reply
Recommended articles