hmdrest1 Posted March 28, 2018 Share Posted March 28, 2018 As topic says.. my tables are wiped.i can create new ones as my db is only developmental,but i wanna know if table wipes are a norm now with 'inactive' accountsand whether there are ways to restore the previous data.thank you for answers Link to comment Share on other sites More sharing options...
wolstech Posted March 28, 2018 Share Posted March 28, 2018 It's definitely not the norm, more than likely they got lost due to the InnoDB corruption issue (we recommend MyISAM for this exact reason...we've never lost MyISAM data, but InnoDB databases tend to go corrupt rather regularly around here). Krydos may have a backup, but no guarantees. Moving so he can check. 1 Link to comment Share on other sites More sharing options...
hmdrest1 Posted March 28, 2018 Author Share Posted March 28, 2018 thanks for your prompt reply, admin, i'll wait Link to comment Share on other sites More sharing options...
Krydos Posted March 29, 2018 Share Posted March 29, 2018 A link to your backup has been emailed to your contact address. Please use myisam in the future to prevent this from happening again. 1 Link to comment Share on other sites More sharing options...
hmdrest1 Posted April 3, 2018 Author Share Posted April 3, 2018 well another problem came up.... i tried to import the .sql file you gave me but it says i have to 'discard' the tablespace before import.i dont see any tables under my current db..am i missing something..?or should i just start everything a new..thanks again for reply.. Link to comment Share on other sites More sharing options...
wolstech Posted April 3, 2018 Share Posted April 3, 2018 Krydos can fix that. It's because the residual crap from the old damaged tables is still there (though you can't see it). If you're in a hurry, you can just create a new DB with a different name and import the backup into that instead. 1 Link to comment Share on other sites More sharing options...
hmdrest1 Posted April 3, 2018 Author Share Posted April 3, 2018 i'll just make a new one i guess. i just wondered what i must do if i run into the same problem next time, if Link to comment Share on other sites More sharing options...
Krydos Posted April 4, 2018 Share Posted April 4, 2018 What is the database name that needs to be dropped? Link to comment Share on other sites More sharing options...
wolstech Posted April 4, 2018 Share Posted April 4, 2018 It was hmdrest1_fatblanket02 based on the picture of the error in his original post. Link to comment Share on other sites More sharing options...
Recommended Posts