Recover accidentally deleted Lightning Calendar

[andya...@gmail.com]

Hey all

Earlier this evening I accidentally deleted my main local calendar
file from within Mozilla Lightning and now only have my two remote
calendars left.

Is there any way I can retrieve this local calendar as it has valuable
information that I need on it.

Any help would be hugely appreciated.

Andy

[Simon Paquet]

andya...@gmail.com wrote on 23. Apr 2008:

> Hey all
>
> Earlier this evening I accidentally deleted my main local calendar
> file from within Mozilla Lightning and now only have my two remote
> calendars left.
>
> Is there any way I can retrieve this local calendar as it has valuable
> information that I need on it.

There is two things that you can try:

1. Try to create a new local calendar with exactly the same name as the
deleted calendar. I've heard rumours that this new calendar will
show all the contents of the old calendar. It may also be that we
have already fixed this bug.
2. Get a copy of SQLite Explorer (not sure whether you need the version
for SQLite2 or SQLite3) and point to the storage.sdb file in your
profile directory. That should allow you to at least take a look at
the contents of the deleted calendar, so that you can retrieve
valuable information from it.

Simon

--
Calendar l10n coordinator
Calendar Website Maintainer: http://www.mozilla.org/projects/calendar
Calendar developer blog: http://weblogs.mozillazine.org/calendar

[Stefan Sitter]

Simon Paquet wrote:
> 1. Try to create a new local calendar with exactly the same name
> as the deleted calendar. I've heard rumours that this new
> calendar will show all the contents of the old calendar. It may
> also be that we have already fixed this bug.
> 2. Get a copy of SQLite Explorer (not sure whether you need the
> version for SQLite2 or SQLite3) and point to the storage.sdb file
> in your profile directory. That should allow you to at least take
> a look at the contents of the deleted calendar, so that you can
> retrieve valuable information from it.

The calendar data is no longer contained in the database once the
calendar is deleted. Therefore the suggestions from above won't work.

I think the only solution is to restore the calendar from a backup
that was done before.

[Bas van den Bosch]

I don't know whether the data will still be in the sql-file, I doubt it.
If you're on windows, using a previous restore point also works. Who
knows, maybe your system made a restore-point a short while ago? Be
aware though that events added after the restore-point will be deleted.
So before reverting, I'd export the still existing calendars to ics and
store them somewhere safe...

gr

Bas

Simon Paquet schreef:

[Stefan Sitter]

Simon Paquet wrote:
> Are you sure of that? We currently don't issue a VACUUM command
> to SQLite to compress the database and remove deleted stuff
> permanently, so it might still be available.

mozStorage is compiled with SQLITE_SECURE_DELETE enabled. This means
old data will be overwritten with zeros when deleting.
http://developer.mozilla.org/en/docs/Storage:Performance#Vacuuming_and_zero-fill

[andya...@gmail.com]

On Apr 24, 5:27 am, Bas van den Bosch <bvd...@chello.nl> wrote:
> I don't know whether the data will still be in the sql-file, I doubt it.
> If you're on windows, using a previous restore point also works. Who
> knows, maybe your system made a restore-point a short while ago? Be
> aware though that events added after the restore-point will be deleted.
> So before reverting, I'd export the still existing calendars to ics and
> store them somewhere safe...
>
> gr
>
> Bas
>
> Simon Paquet schreef:
>

> > andyatho...@gmail.com wrote on 23. Apr 2008:
>
> >> Hey all
>
> >> Earlier this evening I accidentally deleted my main local calendar
> >> file from within Mozilla Lightning and now only have my two remote
> >> calendars left.
>
> >> Is there any way I can retrieve this local calendar as it has valuable
> >> information that I need on it.
>
> > There is two things that you can try:
>
> > 1. Try to create a new local calendar with exactly the same name as the
> > deleted calendar. I've heard rumours that this new calendar will
> > show all the contents of the old calendar. It may also be that we
> > have already fixed this bug.
> > 2. Get a copy of SQLite Explorer (not sure whether you need the version
> > for SQLite2 or SQLite3) and point to the storage.sdb file in your
> > profile directory. That should allow you to at least take a look at
> > the contents of the deleted calendar, so that you can retrieve
> > valuable information from it.
>
> > Simon

Hey guys the system restore point worked. Thanks so much Simon you are
a lifesaver !!!!!!!!!!