That’s right–maybe your MySQL server just isn’t that into you. Or maybe you’ve got a bit of a setup issue.
Here’s the shot: first up, it’s a good idea to keep an eye on your error logs. I reminded myself of this when I saw my MySQL server dying every so often (the MYSQLD process for people who care) and went to go check my error logs. In fact, I used to have a window logged into my server with tail -f error_log running so I can see errors in realtime. I’ve started doing that again.
Basically you go to your server’s statistics/logs directory at a prompt (this is Linux…no idea if Windows is different) and type “tail -f error_log.” That will just scroll the errors. If you just want to read the latest errors, you leave off the -f.
If you don’t have your own server and can only download the log file, I suggest doing it once a week. Set yourself a reminder in Outlook or whatever you use.
All of this to say: keep an eye on your logs. And check there first if something funky starts happening. They are your friends.
You know what else is your friend? The WordPress backup plugin. Use it often.