Yesterday my forum crashed and server too. When Bluehost support rebooted the server, the forum was still crashed, specifically in two tables: phpbb_sessions and phpbb_posts. The first one was fixed, but the second one was still corrupted and would not repair. When I tried to repair using phpmyadmin and WHM, it had long lines about "file missing and skipped" etc.
Then eventually, it showed the table phpbb_posts as being repaired and Ok. However, for some reason, all the forum posts were gone! From 2007 til now! You can see the post topics and titles, but when you click on them, you get this:
http://www.happierabroad.com/forum/view ... =3&t=39479
What the heck happened? Usually when the forum crashes and that table is corrupted, I run the repair command several times and it fixes it and the posts show up again. But this time, somehow the table EJECTED the data and is no longer attached to it, even though the table is marked as Ok and repaired. But all the posts data is missing!Information
The requested topic does not exist.
I tried my usual repair command in MYSQL in phpmyadmin: "REPAIR TABLE phpbb_posts USE_FRM;" which usually works but this time didn't.
What can be done? I don't have any recent backups. My last backup was over 6 months ago I think. Because I am traveling and have thousands of things to do and not enough time for such things. I do not have automated backup because I am on VPS and my VPS has limited storage space, not enough for automatic backups of my site, like I had before on shared hosting. I followed bad advice from my friend Stefan, who recommended I move to VPS hosting, but in doing so, my problems and costs have been multiplied with no benefits! It was the worst mistake and advice I ever received! I was far better off on shared hosting where my site was backed up daily, and server overloads resulted in backup servers coming to help pool their resources, rather than my whole server and site crashing on VPS without backup. I don't understand why you have to pay more on VPS when the benefits on shared hosting are way better and more stable and protected. Stupid.
Anyway, the good news is that all the posts must still be there. Because my database is still the same size at over 2 GB. So the data from all the posts must still be there, right? The problem is reconnecting it all with the table "phpbb_posts". How do you do that? Is there an SQL Query Command that will do it?
I am currently working with Bluehost tech support to fix this. They said they are working on it but it's been 24 hours already and they haven't fixed it yet. Can they? Do webhost admins have special professional tools that can fix such things beyond what the layman has?
What should I do? If I backup my database now, can someone offline, like some database specialist, or software program, some how fix it by reconnecting the post data to the table "phpbb_posts"?
There must be some way to fix it right? I mean computer problems are all fixable. It's just a matter of time and expertise and technical steps and capability right? It's not like bringing the dead back to life. Technical problems always have technical solutions right? It's just a matter of looking deep enough. There are even programs that recover deleted files by re-scrambling the empty space to whatever data was in the deleted file. So with computers, anything is possible right?
Any advice or suggestions? Thanks in advance.