Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

What file stores my addresses and where do I find it?

  • 3 replies
  • 2 have this problem
  • 104 views
  • Last reply by Toad-Hall

more options

To fix another issue I upgraded to Beta and downgraded back to production TB. I now have nothing in my address book. I believe the address book got migrated to a different form when I upgraded to Beta, but I can get it from a backup of the file from before I did all this.

What is the name of the file I need to copy over, and where is it located?

Here is how my settings are set for the address book.

Thanks!

To fix another issue I upgraded to Beta and downgraded back to production TB. I now have nothing in my address book. I believe the address book got migrated to a different form when I upgraded to Beta, but I can get it from a backup of the file from before I did all this. What is the name of the file I need to copy over, and where is it located? Here is how my settings are set for the address book. Thanks!
Attached screenshots

All Replies (3)

more options

Address books are SQLite database files. Are the schemas different between release and beta, I don't know. Can you just copy them insitu and they will work. Probably not.

Did you reuse an existing profile, or was a new one created in your change over? My guess is the later and there is nothing needing copying, just a correct profile to be used.

I also see this question. https://support.mozilla.org/en-US/questions/1380383 which

more options

When I first went to Beta I did not make a new profile. I figured I had a backup of the old profile if something went wrong, but now I wouldn't want to go back to that backup entirely because I've been deleting and moving messages around for weeks and would lose a lot of things that I moved from the server to local folders. But I could get the address list.

When I downgraded I did make a new profile.

Maybe I'll just start over making a new address book. I always hated having every person I've ever emailed pop up when I was typing in recipients for an email. I always wished there were more mailbox cleanup options, like delete all contacts that were collected more than 3 years ago.

more options

re :When I downgraded I did make a new profile.

So it would have a completely new 'prefs.js' file. This means by default Thunderbird will know of the existance of the 'abook.sqlite' (Personal Address Book) and the 'history.sqlite' (Collected Addresses) as they are already in the 'prefs.js' file.

So you can use the backup copy of 'abook.sqlite' and 'history.sqlite'

  • Copy those 'abook.sqlite' and 'history.sqlite' backup files.
  • Exit Thunderbird.
  • Access your new 'profile name' folder.
  • Either remove the current new 'abook.sqlite' and 'history.sqlite'
  • OR rename them adding .bak to name eg: 'abook.sqlite.bak' and 'history.sqlite.bak'
  • Then paste the backup copy of 'abook.sqlite' and 'history.sqlite' into the new 'profile name' folder.

For all other backup address books called eg: 'abook-1.sqlite' The following is a bit more complicated - You would need to copy those files into the 'profile name' folder AND edit the 'prefs.js' file. So first create a temp backup of the current new 'prefs.js' file - put it on desktop - just in case :)

In the original backup locate the 'prefs.js' file and open it using a text editor eg: Notepad In the 'prefs.js' file it has four lines associated with each address book.

I'm going to give an example to explain things. In old profile - now a backup - I created an address book called 'Thunderbird' - it is on old backup and I want it back in the new profile. The info in old backup 'prefs.js' file tells me that 'abook-1.sqlite' is that 'Thunderbird' address book. So that means I would need to copy all four lines related to that file in the old 'prefs.js' and paste them in the correct location in the new 'prefs.js' file - where you see all the ldap info -

Look for lines like this in old backup of 'prefs.js :

  • user_pref("ldap_2.servers.Thunderbird.description", "Thunderbird");
  • user_pref("ldap_2.servers.Thunderbird.dirType", 101);
  • user_pref("ldap_2.servers.Thunderbird.filename", "abook-1.sqlite");
  • user_pref("ldap_2.servers.Thunderbird.uid", "56c4c020-0962-48c9-8289-b2126b270766");

Copy all four lines. Open the new 'prefs.js' file using Notepad Scroll down to where you see the user_pref("ldap_2.servers section put cursor at the end of the line of the last user_pref("ldap_2.servers line and press Enter to create new empty line. Then paste in the four copied lines. Make sure there are no extra emtpy lines which you may have inadvertantly created. Save the 'prefs.js' file

(Obviously, if you have several address books - you would need to repeat that same process for each 'abook-n.sqlite' (where n = number). You may also have an 'impab.sqlite' file - same process. )

Now the new 'prefs.js' knows about the 'abook-1.sqlite' file which I also copied over to new profile. When I restart Thunderbird - that 'Thunderbird' address book reappears in my list of Address Books.

Modified by Toad-Hall