In the past few weeks, every few days my WordPress MySQL database get empty for some odd reason, what I mean is that I get notification that my site is down, when I check what is going on I find that the MySQL database is completly empty, no tables no errors in the logs nothing. I can get the site up and running very fast by restoring the data dump and restart the MySQL service, but this is not a long term solution. The only error I can find from time to time is that the Prvilage.host table cound not be found? I see this error in the even logs.
Here is a few things I already try:
1. Re-install MySQL and wordpress, down this twice once on the old server and one on the new server.
2. Re-build the database and the site.
3. Run Mysql_update, run mysql_db
4. Repair installation several time.
Nothing really helps after afew days it happen again.
I am corrently running MySQL on the some server, Windows 2008 R2, 64 bit.
MySQL verion is 5.1.56 if i remember correctlly, WOrd Pres is version 3.0.1
Anything I can do to resolve this issue? Can I use wordpress with MS SQL? if yes how?