Table 'pages' is marked as crashed and should be repaired WTF???

[PWaddict 367]

I'm building a site locally on laragon and suddenly today when I visited my site at mysite.test I got error from ProcessWire: Error:     Exception: SQLSTATE[HY000]: General error: 1194 Table 'pages' is marked as crashed and should be repaired (in C:\laragon\www\mysite\wire\core\WireDatabasePDOStatement.php line 166) 

I repaired the table "pages" on phpMyAdmin and now I can see my site but the problem is that all pages are GONE except Home. The admin section is empty too. WTF????????

[PWaddict 367]

I tried to browse the pages table in phpMyAdmin and I couldn't. It was saying that the table is still crashed so I repaired it again and now I can't even view my site. I'm getting this: Error: Exception: You do not have permission to execute this module - ProcessPageView (in C:\laragon\www\mysite\wire\core\Modules.php line 1330)

[PWaddict 367]

I guess I have to start again with a clean PW installation. The good thing is that only the "pages" table corrupted. I've exported the database so I can copy on the new installation some important text I had in some fields.

The only way to prevent this from happening again is DAILY BACKUPS. Cronjob Database Backup module by @kixe seems a good choice when you're developing a site.

[cb2004 209]

Something similar happened to me once many years ago. Never got to the bottom of it, it has never happened again.