EMERGENCY! I deleted all items in my Global Scrapbook!

Permalink
I was working with global scrapbook blocks throughout my site and was running into permissions problems. When I went into the Global scrapbook, I saw a notification that the page had a version to approve, which I had never seen before on the scrapbook page in the dashboard. I put the global scrapbook page into Edit mode and deleted the recent version (STUPID I know - as soon as I did it I regretted it).

Now the Global Scrapbook is still listed in the dashboard but it's empty! Is there any way to recover all the items in it? PLEASE!?!

 
admin replied on at Permalink Reply
UPDATE

I discovered that my web host can restore our whole domain, our database, or individual files back to 4:23 am this morning.

Is there is an individual file that I can restore to recover my Global scrapbook items?

If there's not an individual file, would restoring the database work?

I will appreciate any advice anyone can offer.
JohntheFish replied on at Permalink Best Answer Reply
JohntheFish
A complete database restore should do it.

First I suggest making some notes of any other changes since the backup, as restoring the database will obviously erase all such changes.
admin replied on at Permalink Reply
Thanks John.

Is there anything else that I can restore short of the entire DB? That would obviously impact the whole site. Is there anything that I can restore that would only impact the scrapbook? I always like doing the thing that has the lowest impact in situations like this.

And, yes, as soon as this happened I started compiling a list of everything I've done this morning. Thankfully it wasn't a whole lot. I appreciate the tip though.
JohntheFish replied on at Permalink Reply
JohntheFish
The only way to do it perfectly with less than the entire db would require working out numerous tables that are affected and hacking them manually without making any mistakes. Its beyond me, but maybe there is a serious C5 core expert and mySQL expert who could attempt it.

Another approach would be to create a new development site offline, load it from the database backup, then use that to inspect the scrapbooks and recreate them on the main site. There is a slim chance it would work, but it could easily be a dead end because block IDs would all be different. It depends on how the pages and blocks that use the scrapbook are coded, whether they work by ID or handle. It could be a waste of effort.

If it were me, I would copy the existing fault site to an offline site, rebuild/revert the online from the backup, then use the offline copy as a guide to help recreate any changes since the backup was taken.

Funnily enough, an idea I had for an add-on was one that could copy a page or group of pages from one C5 site to another. If it got made, that would also be good for partial backups and restores and the scrapbook is really just a special kind of page. Its a way off though, and certainly too late for you.
admin replied on at Permalink Reply
I restored from a DB backup and all is well, except of course the changes I made after the backup; luckily those were few and minor.

Thanks for your suggestions!