There was once a plone site I help to manage got a corrupted database. Although there was a lot of data already in it as it has been a couple of days of data entry, I still didn't imlement a daily back-up and one day it got corrupted (Data that was supposed to be there is not there anymore. Nothing is listed in the undo list that could help). So how did we finally fix it:
1) Copy the file lib/python/ZODB/fsrecover.py into bin/fsrecover.py
2) We copied the top part from bin/fsdump.py to set the enviroment needed
3) We ran the file bin/fsrecover.py till it came close to the time before the data dissapeard (we actually just stopped it with Ctrl-c)
4) We used that recoved data on another temporary plone site and exported the lost data
5) We imported the data back into the production server and all was well again
But all said and done, best practice is still to just do get the back up running straight away.
Monday, May 26, 2008
Advanced zope db recovery
Posted by
Abdullah Zainul Abidin
at
3:28 AM
Labels: data recovery, plone cms, zodb, zope
Subscribe to:
Post Comments (Atom)

0 comments:
Post a Comment