HelioHost Posted April 28, 2018 Posted April 28, 2018 Username: torrin1, Server: Johnny, Main domain: torrin1.heliohost.org Oops, the original from email is not the account this database is listedunder. The database name is "torrin1_torrinswansondotcom_wordpress" andtied to the email "torrin@torrinswanson.com" as per the sender of thisemail. -Torrin --*Torrin Swanson**Technical Designer, **Engineer**.I.T**Collective Technologies *p: +1 (778) 728 1280w: torrinswanson.com On Sat, Apr 28, 2018 at 1:51 PM, Torrin Swanson wrote: > Hi there,>> I visited my wordpress site in which the content is being hosted on> heliohost. One day I loaded the site and was greeted with the "Setup your> Wordpress site" initial screen. I thought that was weird, so i went and> checked my database and it seems to be corrupted. All the tables get listed> through SequelPro and when I login through cPanel. But when clicking on one> of the tables listed, it comes back with a #1146 table not found error. All> the content of my site is located within those problematic tables. Can we> trace back and see how this database became corrupted. I would think it> happened a couple months ago as I am finally getting around to writing an> email.>> Screenshots attached for more clarity.>>> Cheers,> Torrin>>> --> *Torrin Swanson*> *Technical Designer, **Engineer**.I.T*> *Collective Technologies *> p: +1 (778) 728 1280> w: torrinswanson.com>
wolstech Posted April 28, 2018 Posted April 28, 2018 Were they Innodb tables? If so, innodb did go corrupt on Johnny again and lost all the data for a second time. You'll need to make a new database and restore a backup. We HIGHLY recommend not using innodb if you can avoid it. We've lost innodb data too many times to count, but have never lost Myisam data in our 10+ years in operation. If you really need innodb, I'd recommend moving to Tommy to reduce the risk of corruption caused by load/server crashes.
Recommended Posts