-
The following tutorial did not work https://rankmath.com/kb/delete-old-analytics-data/ and the database is still bloated with rank-math data. We are over our space limit which is causing problems. How do I purge all this old data from the database? I’ve attached a screenshot for you to look over There are hundreds of tables like these in our database.
Thank you
John
-
Hello,
We apologize for the issue you are facing with your website’s database being bloated with Rank Math Analytics data. Thank you for raising this concern.
To purge old data from the database, you can try the following steps:
-
Purge Analytics Cache: If you haven’t already, you can use the option to purge the Analytics cache. This feature is available in Rank Math 1.0.50 and above. It will help clear out any unnecessary data that may be causing bloat. You can find this option in your WordPress dashboard under Rank Math settings.
-
Rebuild Index for Analytics: If you are still experiencing issues, consider rebuilding the index for Analytics. This can help ensure that the data being displayed is accurate and may assist in reducing the size of the database.
-
Delete Old Data Manually: If the above methods do not resolve the issue, you may need to manually delete old analytics data from your database. You can look for tables with a prefix like
*_rank_math_*and drop them if they are no longer needed. Be cautious when doing this to avoid losing important data.
If these steps do not resolve the issue, please reply to this ticket with your screenshot, and a human agent from the Rank Math Support team will take over and assist you further.
Thank you for your patience, and we hope to resolve this issue for you soon!
Sources:
How to Delete Old Analytics Data & Start a Fresh Import
Rank Math Status and Tools » Rank Math
How to Completely Uninstall Rank Math From Your Website » Rank MathHello,
Please navigate to WordPress Dashboard > Rank Math > General Settings > Analytics and click on the Delete Data button to clear the database table.
Once done, you can reduce the number of days in the Analytics Database option, and after saving the changes, click Update Data Manually.
Let us know how it goes. Looking forward to helping you.
Thank you.
Hello,
Since the Database entries persist despite deleting them from within Rank Math it implies there might be some issues with the database.
To rule out the potential of it being an issue of corrupt database tables, in your WordPress dashboard, go to Rank Math SEO > Status & Tools > Database Tools, and when there click on Re-create database Table button:
On the same page, click the Fix Collations button. This will check and fix any database collations issues that might affect Rank Math Analytics:
If that still doesn’t help then the issue might be from the WordPress installation. Please follow the steps below in that case:
– Backup your entire site including the database.
– Use the WordPress built-in repair tool by adding the following line to your
wp-config.phpfile:
define('WP_ALLOW_REPAIR', true);Note: You’ll need to add the code snippet just before the /* That’s all, stop editing! Happy publishing. */ line:
– Then visit
http://yourdomain.com/wp-admin/maint/repair.phpand follow the instructions to repair the database. Replaceyourdomain.comwith your actual site’s domain name.– Remove the line from your
wp-config.phpafter repairing.You can refer to this guide: https://www.wpbeginner.com/beginners-guide/how-to-repair-wordpress-database/
Let us know how this goes. Also, let us know if you have further questions or concerns.
Thank you.
-
The ticket ‘Websites database is extremely bloated with Rank Math Analytics Data’ is closed to new replies.