Loading...
 
Skip to main content

Architecture / Installation


Restore problems

I had to restore my wiki because I ran a script to insert a heap of wiki pages from another source and the first run didn't go so smoothly. No problem because figuring this might well be the case I took a backup of the database before that first run. After restoring (it and the backup were done through cpanel) from that back I discovered a heap of problems:

images were missing from the image gallery. Or partially missing. I had one gallery that was telling me it had 7 pages but no actual images. Images were stored in the database.

Likewise in my file galleries many of the files were missing. They too were stored in the database.

Pages and indeed pagenames had developed some nasty unrecognised character symbols (the black backgrounded question mark in a diamond symbol) where there had once been apostrophes, inverted quotes, three periods in a row and doubtless a few others too.

So now my site is scattered with links to images that don't always fully exist and horrible formatting exceptions in the pages.

Can I fix this and how do I avoid it in the future? So you know, my back ups are actually worth having...

I've been looking into it myself and strongly suspect it is a character encoding issue but so far as I can see my install and recovery all have been done to the expected standard in the expected way so when the problems came in I don't know. And for all of the pitfalls of character encoding I've read in the last day I've read no useful solutions or diagnostics so I could be barking up completely the wrong tree with this theory.

Right now I'm looking at a long boring manual job to put everything right with no guarantee that once it is corrected it'll stay that way if/when I need to perform another restore.

Anyone got any insight or pointers that might help?

Cheerio for now,

Alan