Resolved Does anyone have a clue how to resolve this?

[Colonel36]

Server operating system version

Ubuntu 20.04

Plesk version and microupdate number

Plesk Obsidian18.0.57

I'm afraid I'm not that learned with these matters and any help whatsoever would be greatly appreciated. Thanks

Warning: Database "wp_6t1x6"
Unable to make database dump. Error: Failed to exec mariadb-dump: Exit code: 3: mariadb-dump: Error 1034: Index for table 'n2d3i_wpr_above_the_fold' is corrupt; try to repair it when dumping table `n2d3i_wpr_above_the_fold` at row: 0

 

[Colonel36]

I've tried to repair it, but the problem still persists?

 

[Bitpalast]

The index must be removed and recreated. If this doesn't work (e.g. maybe the index cannot be removed, because it is corrupt), the whole table must be removed and recreated (from a backup peferrably).

 

[Colonel36]

Thanks.
Is there an article of how to remove/recreate the index?
Many thanks

 

[Bitpalast]

Removal is easy, simply click on "phpMyAdmin" in the webspace control panel "Databases" menu, then go to the table and edit the structure. Re-creating the index should also be easy, because in phpMyAdmin you can simply do this by GUI. The only thing you'll need to know is what the index was about, e.g. what field it contains, whether they are "unique", "primary", etc.

 

[Colonel36]

Thanks. I deleted it, and everything appears to be fine.

 

[Bitpalast]

It will work without the index, but accessing a table without a proper index also results in full tables scans whenever a SELECT query is brought against the table. I advise to re-create the index as it was supposed to be. This will greatly reduce the number of datasets that need to be read upon SELECTs, hence it will greatly increase the speed to query that table.

 

[Colonel36]

Thanks.
I deleted the table since it was empty. Now the table has appeared again and is populated and working fine. A great many thanks for the support!