.: I must report that I heard from the creator of the WordPress Database Backup Plugin, who noted the following:
—————————
Hello Randy,
I’m sorry to hear that you’re having trouble with your blog. You can
rest assured that the database backup plugin does not make any changes to your database, so it could not be the cause of your losing any data.
Please note that the problem mentioned at the link above is not
related to yours. That person was saying the *backup files*–the
ones emailed out–were empty, not the blog itself. If your WordPress
site has actually lost all its posts, it could *not* be caused by the
plugin. Perhaps your site has been attacked, or you have some other
problem. Did you upgrade any other themes or plugins recently? Have
you upgraded to the latest version of WordPress? Are there any error
messages at all?
Regards,
Austin
——————————
So now I am worried that my site was hacked or attacked. 🙁
Have you tried:
– deactivating all plugins to see if this resolves the problem? If this works, re-activate the plugins one by one until you find the problematic plugin(s).
– switching to the Twenty Ten theme to rule out any theme-specific problems?
– resetting the plugins folder by FTP or phpMyAdmin? Sometimes, an apparently inactive plugin can still cause problems.
– re-uploading the wp-admin and wp-includes folders from a fresh download of WordPress?
– increasing the memory available to PHP?
http://wordpress.org/support/topic/253495#post-1017842
– checking your database?
Hello esmi, and thank you for replying. I have done none of these yet, but have forwarded your post to my ISP HelpDesk, which is working on the problem at the moment. I don’t want to try anything until I hear back from them.
Again, thank you for these suggestions. I will definitely return to this pending a reply from my ISP.
Kind regards,
Randy
esmi, I wanted to report that the HelpDesk at my ISP was able to restore the posts to my blog, and the 21 pages. They reported:”We wound up having to pull the backup and swap out that copy of the database for the one that was in place. The index could not be rebuilt on the bad posts table, even after going through all our bag of tricks. I did run an optimize on the restored database, just to make sure we’re starting from a clean slate.”
So, everything is ok for now! And I WILL be backing up my db now, at least once a week!
– Randy
Glad to hear that you’re back up & running. And that you now have a good backup policy in place.