Questo sito potrebbe offrire funzionalità limitate durante le operazioni di manutenzione per migliorare l'esperienza utente. Se un articolo non risolve il tuo problema e vuoi richiedere supporto, la nostra comunità di supporto è pronta ad aiutarti tramite @FirefoxSupport su Twitter e /r/firefox su Reddit.

Cerca nel supporto

Attenzione alle mail truffa. Mozilla non chiederà mai di chiamare o mandare messaggi a un numero di telefono o di inviare dati personali. Segnalare qualsiasi attività sospetta utilizzando l'opzione “Segnala abuso”.

Ulteriori informazioni

Questa discussione è archiviata. Inserire una nuova richiesta se occorre aiuto.

Updating calendar data database file

  • 2 risposte
  • 0 hanno questo problema
  • 3 visualizzazioni
  • Ultima risposta di malte.forkel

more options

Hi,

As far as I can tell, the calendar database file calendar-data\local.sqlite is updated when I quit Thunderbird, but not every time I make a change to a calendar entry or task or at regular intervals. How can I trigger an update of local.sqlite before I run my daily backup?

Thanks, Malte

Hi, As far as I can tell, the calendar database file calendar-data\local.sqlite is updated when I quit Thunderbird, but not every time I make a change to a calendar entry or task or at regular intervals. How can I trigger an update of local.sqlite before I run my daily backup? Thanks, Malte

Tutte le risposte (2)

more options

Ideally, you would exit Thunderbird before backing up anything in the ....Appdata/Roaming/Thunderbird folder. There are many files which get updated/ written to upon exit.

Including eg: preferences, address book, calendar, session data

In your 'profile name' folder is 'calendar-data' folder containing 'local.sqlite' - the main database file and also 'local.sqlite-wal' which is a 'Write Ahead Log' (wal) file. It's a type of cache file used to speed up process of what you viewing and upon exit it synchs with the local.sqlite to keep it up to date. So it may contain more recent data. 'local.sqlite-shm' is a shared memory file to faciliate the process.

So actual database is 'local.sqlite', but when running Thunderbird and using calendar it first checks to see if there is anything in the *-wal file because it may contains changes as yet not applied to the database. When you exit Thunderbird all the current data is written to the database file to update it before fully closing down.

Hence if you exit Thunderbird you will find the 'calendar-data' folder does not have any *-wal nor any *-shm files. They get recreated when you start up Thunderbird.

more options

Thanks for the great explanation.

I understand that a timely exit would guarantee an up-to-date backup. Given all the additional files you're mentioning, can a backup performed while Thunderbird is running be used to restore the complete state of the application at the time of the backup or might some information get lost?

Would the API allow the implementation of an extension that triggers what Thunderbird does before exit, i.e. update all the data files?