How to rebuild mail database for POP accounts

How to rebuild mail database for POP accounts

Hello all

I did a forum search and couldn't find an answer to this.

I have some mails in Mailing-lists folder that just do not belong to the related ML.
Also, some mails in Sent are not sent by me but received 2 months ago.

I think the problem is related to the database index. I would like to rebuild the index so I can tell if it's a bug or just an inconsistency.

Thanks in advance for any reply

If the database and or the index is messed up for a pop account, there's no non-destructive way to fix it (short of manually editing Opera's files with a text editor and hex editor).

You can install another Opera separately (don't upgrade, so you get a separate, fresh profile) and import your mail into it. But, depending on the situation, using the Opera 7/8/9/10 import option will just reproduce the corruption in the new install. That depends on what's up messed up though.

You could close down Opera and try deleting the indexer folder and or the index.ini file. But, you're going to lose filters and labels etc. And, you might lose your feeds access point and other stuff. If the problem is in the database though, deleting omailbase.dat will just mess up everything completely.

The only way to do things (if using the Opera 7/8/9/10 importer to import into a new Opera profile doesn't work) is to do a generic mbox import for the pop account's message's in the store folder into a new Opera. But, this will indeed cause you to lose all context of messages, including losing labels, filters and what's in trash etc.

Also, note that when importing into a new Opera, your contacts and username/password info are not imported. So, you'll need to fix that too. For your username/password info, you'll have to transfer your wand.dat to the new profile. For your contacts, you'll need to export them to an adr file, remove all m2indexid lines from it and import it into the new Opera.

Also, when importing into a new Opera, you'll lose your feeds. You can export your feed list and import it into a new Opera, but you'll lose all already-fetched messages.

So, you're basically left with backing up your mail folder and experimenting.

Always try setting opera:config#consistency to 0 and restarting first just in case you get lucky and that fixes your problems.

Or, you could just try this, but I don't think it does anything.

Burnout, thanks for the extensive reply on all the means I have.

The link didn't help, nor the consistencey setting change.

We need a mean to reindex almost everything apart from unread. Even some of my labels are corrupted (I have mails in it with no labels and some with).

I will not try any other method burnout426 provides, since I don't want to loose (again) unread, RSS, etc.

There should be an "Opera-certified" solution.

Regards

Originally posted by mmichel:

Burnout, thanks for the extensive reply on all the means I have.

You're welcome. There's just not much you can do.

Originally posted by mmichel:

I will not try any other method burnout426 provides, since I don't want to loose (again) unread, RSS, etc.

You did the "backup your mail folder" part in:

Originally posted by burnout426:

So, you're basically left with backing up your mail folder and experimenting.

before you tried things, right?

Or, did you not back up your mail folder and lost all those things forever?

Originally posted by burnout426:

Originally posted by mmichel:

I will not try any other method burnout426 provides, since I don't want to loose (again) unread, RSS, etc.

did you not back up your mail folder and lost all those things forever?

I was talking about my upgrade when they changed the mail system.
And actually, loosing unread status and labels, event if the indexes are ok is not worth it IMO.

Originally posted by mmichel:

I was talking about my upgrade when they changed the mail system.

And actually, loosing unread status and labels, event if the indexes are ok is not worth it IMO.

O.K.

Originally posted by burnout426:

Always try setting opera:config#consistency to 0 and restarting first just in case you get lucky and that fixes your problems.

Hi Burnout426,

In which file will I find 'config#consistency' so that I can reset it? I am experienced in this venue. Thanks,

/* Phil */

ps: my problem is that some 'sent' mail just disappeared and I am wondering whether it is tied to some type of indexing that has gone astray. Using POP etal.

click here