Your site probably has too much content; such as images, posts, themes, etc. Try creating a new site with a new database and link to it on the old site. Alternatively, you can try using multi-site, although I don’t know if that part will work or not.
The site has 300 posts at the most. I have been deleting spam comments. I think the site is quite small compared to the other sites out there
If that’s it….I don’t know how the database would be in the way unless your hosting plan is too small…sometimes hosting CAN cost a lot. I would get an ad revenue service put on your site, and use the money to buy bigger & better hosting. What’s your domain name?
http://robcubbon.com
I’m using quite a good hosting plan. I have the capacity. I just don’t think the database should be 2GB – it’s only text afterall?
Howdy,
Not related to your hosting, and as you know, images are not stored in the DB, let alone the table in question 🙂
Have a read through this post and check the provided fix. But remember to make a backup of your DB before performing the fix.
http://spblogger.com/2011/09/01/clean-up-wordpress-database-wp_commentmeta/
Cheers!
Lyle
Hello Lyle. Thanks very much for your help. I’m sure you’re right about the Akismet issue highlighted in the SPblogger article.
However, I think you were running the Succuri check while my website was down during ongoing measures to fix this issue. If you go back to that link and hit Re-Scan I get a full bill of health 🙂
