I am using Mediatemple's Grid Hosting (GS) platform to host a wordpress site. The DB tables are using the MyISAM engine.
I had noticed that a previous article had disappeared from the site. At first I thought it was a user mistake so I took a look at the DB backup that I had made soon after the article was posted and I noticed that the article had an ID of 11300 (auto_increment) and there were autosaves that had an ID all the way to 11307. When I checked the database, the ID of 11300 was occupied by a newer post which means that the value got re-set.
I did a diff of the database dump between the one taken just before the article disappeared and today. There was no content change other than the standard for some new posts and comments being added.
Mediatemple says it is a security vulnerability and that there is nothing wrong on their end. They suggested that I imported data (which I definitely didn't do) or a 3rd party doing it without my knowledge. But why would anyone go through the trouble of re-importing the database without adding any exploits or backdoors?
So my question is, is there any other possible explanation for this? Botched replication or some other oddity? I am not so much concerned about getting my data back but very concerned about future losses.