Upgrade your account to a Community Supporter account and remove most of the site ads.

Reply to thread

Message: <blockquote data-quote="Michael Morris" data-source="post: 2820202" data-attributes="member: 87">Ok, first the good news - the binary log files which mysql uses to track transactional changes on the database seem to be intact. Theoretically these logs can be played back to restore *everything*But there's a catch (and here's the bad news) - binary logging restoration is something I've never tried until tonight and I wasn't able to get it to even start due to duplicate entry keys. I need to find the point to start at and this will take time -- a considerable amount of time considering the log files are several times larger than the db itself.Presuming I can find the correct point to start I can run a restore then, using a process similar to the one used to merge the posts of the ISRP board I can pull posts out of this database and into the restored one.If this works though it will take time - a considerable amount of time I might add -- according to one website it took a server considerably beefier than ours 9 hours to playback the logs. Also, to be safe during the playback I'll need to shut down any and all external db processes - that means no circvs maximvs, no store, nothing.  If I do this ENWorld goes dead to the world except for a pointer page for at least two days.The reason I'm posting this here instead of the staff forum is I've never done this before and I know there are at least a couple of database techies on this board.  I could use some help, cause at this point this little PHP jockey is over his head.</blockquote>

Verification