Jordan Miller Posted September 20, 2020 Share Posted September 20, 2020 Hey guys, wondering what I should do. I asked my host to make a backup of my forum database before upgrading to 4.5, but he had this to say: we noticed the following for this database:mysqldump: Error 1194: Table 'membersshop_logs' is marked as crashed and should be repaired when dumping table `membersshop_logs` at row: 633352So, you might need to fix this first then we will do the backup for the database again. Not sure what this means or what to do. Thoughts? Any help would be greatly appreciated! Link to comment Share on other sites More sharing options...
SC36DC Posted September 20, 2020 Share Posted September 20, 2020 (edited) 38 minutes ago, breatheheavy said: Hey guys, wondering what I should do. I asked my host to make a backup of my forum database before upgrading to 4.5, but he had this to say: we noticed the following for this database:mysqldump: Error 1194: Table 'membersshop_logs' is marked as crashed and should be repaired when dumping table `membersshop_logs` at row: 633352So, you might need to fix this first then we will do the backup for the database again. Not sure what this means or what to do. Thoughts? Any help would be greatly appreciated! Maybe @TheJackal84 can help out, since it seems to have to do with Members Shop. Your hosting didn't offer to run a repair on the table? You can try and repair it yourself if you have the option. Not a good start to you finally beginning the upgrade to 4.5 ... don't be discouraged, everything will work itself out. Did you manage to get your theme updated, or you going with a new theme? Good luck with everything. Edited September 20, 2020 by SC36DC Link to comment Share on other sites More sharing options...
Eudemon Posted September 20, 2020 Share Posted September 20, 2020 REPAIR TABLE `<table name>`; Link to comment Share on other sites More sharing options...
Jordan Miller Posted September 20, 2020 Author Share Posted September 20, 2020 1 hour ago, SC36DC said: Maybe @TheJackal84 can help out, since it seems to have to do with Members Shop. Your hosting didn't offer to run a repair on the table? You can try and repair it yourself if you have the option. Not a good start to you finally beginning the upgrade to 4.5 ... don't be discouraged, everything will work itself out. Did you manage to get your theme updated, or you going with a new theme? Good luck with everything. 4 minutes ago, Eudemon said: REPAIR TABLE `<table name>`; My host said this: You can try to repair it via cPanel otherwise you need to contact your developer to look at this. Should I try that? SC36DC 1 Link to comment Share on other sites More sharing options...
Eudemon Posted September 20, 2020 Share Posted September 20, 2020 you have access to phpmyadmin? go to the database find the table and click repair Jordan Miller and SC36DC 2 Link to comment Share on other sites More sharing options...
SC36DC Posted September 21, 2020 Share Posted September 21, 2020 1 hour ago, breatheheavy said: My host said this: You can try to repair it via cPanel otherwise you need to contact your developer to look at this. Should I try that? Definitely. I've done it before in the past. It worked for me. Jordan Miller 1 Link to comment Share on other sites More sharing options...
Jordan Miller Posted September 21, 2020 Author Share Posted September 21, 2020 3 hours ago, Eudemon said: you have access to phpmyadmin? go to the database find the table and click repair 1 hour ago, SC36DC said: Definitely. I've done it before in the past. It worked for me. Appreciate the feedback! Do I need to repair this specific table? Or repair the entire database? Link to comment Share on other sites More sharing options...
SC36DC Posted September 21, 2020 Share Posted September 21, 2020 Look for table 'membersshop_logs' and try and repair this one. Jordan Miller 1 Link to comment Share on other sites More sharing options...
Jordan Miller Posted September 21, 2020 Author Share Posted September 21, 2020 26 minutes ago, SC36DC said: Look for table 'membersshop_logs' and try and repair this one. Alright, just repaired that table I believe! Let's see what my host says now 🙏 Thank youuuuuu Link to comment Share on other sites More sharing options...
SC36DC Posted September 21, 2020 Share Posted September 21, 2020 3 minutes ago, breatheheavy said: Alright, just repaired that table I believe! Let's see what my host says now 🙏 Thank youuuuuu Link to comment Share on other sites More sharing options...
Jordan Miller Posted September 21, 2020 Author Share Posted September 21, 2020 20 minutes ago, SC36DC said: Haha. This is what it said btw. The table is 158MB SC36DC 1 Link to comment Share on other sites More sharing options...
Jordan Miller Posted September 21, 2020 Author Share Posted September 21, 2020 38 minutes ago, SC36DC said: It worked!!! Backup was successful 🙏🙏🙏🙏🙏 SC36DC 1 Link to comment Share on other sites More sharing options...
CoffeeCake Posted September 21, 2020 Share Posted September 21, 2020 That may not be good. https://dba.stackexchange.com/questions/68187/mysql-wrong-bytesec-0-0-0-at-linkstart-0 Do you have backups from before the corruption? Are you using MyISAM instead of InnoDB? SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'breathh_invision'; Do any of the results of the above query tell you MyISAM? This looks to be a non-core table--something to do with a 3rd party plugin perhaps? How important is the data in this table? What is it? SC36DC 1 Link to comment Share on other sites More sharing options...
Recommended Posts