Hello,
I’m sorry to hear about the issue you are facing while trying to generate a backup using cPanel toolkit. The error message you provided indicates a problem with the ‘NvGq2_rank_math_404_logs’ file not being found, which is related to Rank Math.
To address this issue, you can follow these steps:
-
Check Your Database Login Credentials: Ensure that the database login credentials in your wp-config.php file are correct. Incorrect credentials can lead to database connection issues.
-
Repairing Corrupt Database: There might be a chance that your database is corrupted due to new plugins or themes. You can refer to our troubleshooting guide for assistance in resolving this error.
-
Issues With Your Database Server: If the above steps do not resolve the issue, it’s recommended to contact your hosting provider as it could be an issue with your database server.
If the hosting provider has indicated that it is a plugin error, you can also try the following:
- Deactivate any recently installed plugins or themes that might be causing conflicts.
- Check for any corrupted plugins or themes and deactivate them.
If the issue persists after following these steps, please feel free to reach out to our support team by clicking here. Our team will be more than happy to assist you further.
Thank you for bringing this to our attention, and we appreciate your patience as we work to resolve this issue for you.
Warm regards.
Sources:
How to Fix the Error Establishing a Database Connection in WordPress » Rank Math
WordPress Database Error Commands Out of Sync; You Can’t Run This Command Now » Rank Math
Fatal Error Happening on Some Installations After 1.0.49 Update » Rank Math
Hello,
Thank you for contacting us and sorry for any inconvenience that might have been caused due to that.
Please head over to your WordPress Dashboard > Rank Math > Status & Tools > Database Tools and click the Recreate Missing Database Tables button and see if that works for you: https://rankmath.com/kb/rank-math-status-and-tools/#recreate-missing-database-tools
Please note that some options are only available when you enable the Advanced Mode in Rank Math. If Database Tools is not showing, please switch to the Advanced Mode: https://rankmath.com/kb/switch-from-easy-to-advanced-mode/
Let us know how it goes. Looking forward to helping you.
Thank you.
I am still getting the same error after rebuilding databse — Connecting to localhost… mysqldump: Got error: 1017: Can’t find file: ‘NvGq2_rank_math_404_logs’ (errno: 2 – No such file or directory) when doing LOCK TABLES
Hello,
Please navigate to Rank Math > Dashboard > Modules then disable and reenable the 404 Monitor module. This should recreate the rank_math_404_logs.
Don’t hesitate to let us know if you need help with anything else.
Same error — Connecting to localhost… mysqldump: Got error: 1017: Can’t find file: ‘NvGq2_rank_math_404_logs’ (errno: 2 – No such file or directory) when doing LOCK TABLES
Hello,
Please navigate to your database and confirm if the rank_math_404_logs table exists on your database.
If you can find the table, then the issue is from your host. But if you were unable to find the table, then please share access to your website with us so we can help investigate the issue further.
Thank you for choosing Rank Math
I found the table even tried to drop it and it said the file does not exists
Hello,
If you’re unable to drop the table, the issue could be from your host’s end. We suggest reaching out to them as well.
Have you tried other actions on the table? For example, have you attempted renaming it before trying to drop it? Also, please check if the table has any data or columns on your end. If it does not, you can create dummy data and try again. Here’s a sample column/data you can use:
Please feel free to reach out if you need further assistance with anything else.
Hello,
I have updated the sensitive data as requested. Can you please check further?
Thank you.
Hello,
Unfortunately, our scope of support does not extend to live support via phone calls.
You should reach out to your host to help you resolve this.
Let us know how it goes and please do not hesitate to let us know if you need our assistance with anything else.
Thank you.
this is what get when i try to drop the table: I have added xxxx to the table name in the example bellow to hide the table name.
DROP TABLE NvGq2_rank_math_404_logs
Mensagem do MySQL: Documentação
#3605 – Storage engine can’t drop table ‘xxxxxxxxx.NvGq2_rank_math_404_logs’ because it is missing. Use DROP TABLE IF EXISTS to remove it from data-dictionary.
Hello,
The table is showing in the database but it cannot be dropped and that usually is caused by an incorrect engine set on the database table.
Also, the fact that you have a mix of uppercase and lowercase letters can cause some issues with the MySQL commands as we have seen this in the past with WordPress.
The only possible solution here is to ask your hosting provider to forcefully drop the table from the database so that the backup can go ahead.
Don’t hesitate to get in touch if you have any other questions.
Hello,
Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.
If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.
Thank you.
