I'm trying to get back to kmail after the 4.8 update and it's working OK

But I've run into a BIG problem

I've got a bunch of mail in local folders and I've discovered that quite a bit
of it is has somehow moved to the dreaded akonadi/file_db_data file

This is the actual content of the messages not just the header

The messages are now GONE from my local folder maildir setup

I've tried moving the messages into another local folder, but they remain firmly
stuck in file_db_data

One more thing ... I am NOT just imagining this. From what I've read this
is not supposed to happen but it is happening.

Is there any way to get my mail back into the correct local folders and prevent
this happening in the future.

thanks ...

from bad to worse - now some mail has been definitely lost,
remaining ONLY in the file_db_data in ~/.local/share/akonadi

How can I get my mail to return to my local mail folders?

Anyone have any idea on this? Is it even possible to import mail
from file_db_data?

Now it appears that some local mail is migrating out of local folders
into the akonadi file_db_data file ...

Is there no way to bring sanity to my local mail folders?

I thought I'd pass on the latest oddity even if no one knows how to fix
any of this.

Now I've got a bunch of messages that seem to have migrated to
~/.loca/share/akonadi/akonadi.db

this is a binary file but the messages in question have disappeared from
both my .local-mail.directory and the file_db_data file ...

but the subject and contents seem to be in akonadi-db

I can still access these messages in kmail ...

I just don't understand why kmail cannot leave local mail in the proper local
mail folders

At this stage I would recommend you write a email to the kdepim-users@kde.org mailing list. It seems that some form of internal issue is preventing KMail/Kontact from writing to your local mail store - so it is holding them as pending changes.

You can verify this by examining the *.dat files at ~/.config/akonadi/

As to why that *.db file is being used - I highly suspect something/someone has changed your settings - that sounds like the SQLite backend.