SQL Error when making a backup

[Jordan Miller]

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: 633352

So, 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!

[SC36DC]

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: 633352

So, 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

[Eudemon]

REPAIR TABLE `<table name>`;

 

[Jordan Miller]

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? 

[Eudemon]

you have access to phpmyadmin? go to the database find the table and click repair

[SC36DC]

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]

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?
 

[SC36DC]

Look for table 'membersshop_logs' and try and repair this one.

[Jordan Miller]

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

[SC36DC]

3 minutes ago, breatheheavy said:

Alright, just repaired that table I believe! Let's see what my host says now 🙏 Thank youuuuuu

[Jordan Miller]

20 minutes ago, SC36DC said:

Haha. This is what it said btw. The table is 158MB

[Jordan Miller]

38 minutes ago, SC36DC said:

It worked!!! 
 

Backup was successful 🙏🙏🙏🙏🙏

[CoffeeCake]

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?