jihymas

Well, I was able to import the remaining posts by deleting all the previously recovered posts from the database with Heidi-SQL, then deleting all the references to those posts from the post metafile, then repeating the export, chop up, import process.

However, I’ve lost all the links from the navigation panel of my theme and all my readers will have to re-register. *sigh*

That’s not my avatar, by the way. I’m more than twelve years old.

I also note that my moderation keys and blacklist keys from the wp-options table of the SQL were also not transferred to the Export file.

Manual copying from the database on the old server produces text files of 162KB and 954KB, respectively, so this was not a trivial oversight.

Those missing posts are not in the raw XML, by the way. This appears to be a WordPress error, not a wxrsplitter error.

So I chopped up the raw XML with the utility “wxrsplitter” and was able to upload the pieces.

However, I now find that there are 1,163 missing posts; everything with a post ID >= 16,886. Oddly, #16869 was successfully imported, but #16864 was skipped. This cutoff point looks suspiciously close to 2^14 = 16,384, but I don’t know if that’s significant.

I have sent the extracts from the logfile to the indicated eMail.

Please let me know if you’d like anything more.

“WordPress version: 2.3.3”

I know, I know. At least, I know now. Until today, I hadn’t realized that my 5-month old installation was so vulnerable. I’ll be updating soon, believe me.

I’ll have a look around for some utilities that will resolve the issue – unfortunately, I can’t use aide, as suggested by whooami because my host runs Windows. I’m in the (very slow) process of changing hosts, though, so maybe I’ll just wait until then.

I don’t use any plug-ins. I will admit, I am averse to any sort of widgetry on my machines – unless it’s widgetry I’ve built myself – because

• It’s just another thing to learn, understand and check
• They introduce vulnerabilities of their own
• I spent too much time in the eighties and nineties, trying to figure out why installation of one programme broke another
• I loathe fiddling. I know people who take days fiddling around with their MS-Word settings and can’t use it unless it’s personalized to hell-and-gone … the idea just drives me crazy

All of which are at best generalities and at worst cover-stories for laziness, but it would really be appreciated if the fine folks at WordPress could port some freeware into one of their upcoming versions and make it fully integrated.

I was able to resolve my problem – I think. I wrote a post about it.