Hi everybody. I'm using and loving KDE environments since many years. I turned to KDE from Gnome because I really loved the clean style of apps and chance of full configurations in pure Linux style. But.
But since some releases the complexity is becoming more and more problematic just for simple operations.
Top of this rouinous path is represented, in my opinion, the implementation of Akonadi in KDE 4.7.2
I don't discuss about its efficence. At all. But.
I mean ... I'm a Linux server administrator, but I can't find a way to backup kjots content of my desktop KDE.
This is frustrating me.
Before Akonadi, it was simple to do many things. Just find the correct file, edit it and the job was done.
Now it's simply impossible. I spent all day in trying (without succedd) understanding where my kjots contents are stored. I can see using the application, I can't find on the filesystem to copy them and use it in another KDE machine.
I found that new or modified kjots entries are located in:
~/.local/share/notes/.pmgvvfOE2W.directory/hOoN8IsMgr/new/ (DOUBLE HIDDEN DIRECTORY !!!)
and stored in files with name like "319372365.R125.VirteX"
It reminds me Outlook way to store data
I can't find at all my old kjots entries ... I see but I don't know where they are ...

Backup Akonadi required to install mysql-server, otherwise Akonadytray utility can't do the backup.
Once I succeded to do the Akonadi backup, I didn't find any useful file inside it.
Any clue? Any answer?
Many thanks.
g

there's a systemtray app for backing up and restoring Akonadi called akonaditray (I'd guess using "stop Akonadi" first might be a good idea)


kindly post your experiences

Thanks for your reply. But, as I wrote in my first post, to backup Akonadi database, I had to install mysqlserver to let that backup tool use mysqldump. It seems to me absurd to have a sql server package installed just to be able to extract my notes. Anyway, I didn't find my notes in that database. How import only them in another KDE installation?
g

gdavid wrote:Thanks for your reply. But, as I wrote in my first post, to backup Akonadi database, I had to install mysqlserver to let that backup tool use mysqldump.

If you are on Kubuntu like your Avatar suggests you should find mysqldump in the package mysql-client, at least in newer versions. If I recall correctly it was in mysqlserver which was a packaging issue in older versions (look at the package descriptions, conflicts etc in aptitude or whatever you use for package mangement). The new server package is mysql-server.

gdavid wrote:Thanks for your reply. But, as I wrote in my first post, to backup Akonadi database, I had to install mysqlserver to let that backup tool use mysqldump. It seems to me absurd to have a sql server package installed just to be able to extract my notes. Anyway, I didn't find my notes in that database. How import only them in another KDE installation?
g

That sounds like a packaging problem, not specifically a KDE problem. I have mysqlserver installed anyway on openSUSE.

The reasons for using mysql at present are given at:
http://techbase.kde.org/Projects/PIM/Ak ... adi_use.3F

Thanks for your reply. I agree about package problem of mysqldump (in my opinion is correct to have it on mysql-server server package ...). But this do not solve the complexity of exporting only kjots notes to another kde installation. I always have to export ALL the Akonadi database (many Mb for just some kb of notes ...) This results in a problem with other PIM contents I don't want to be migrated.
I could be enthusiastic about this new architecture for PIM data via Akonadi server IF I could connect different machines to a single remote Akonadi server, but it doesn't seem to be possible (it wold be great also for server environments!). I'm I wrong? If I'm not wrong, I think, for the moment, to leave KDE PIM and use traditional tools like Thunderbird, BasKet and so on ... I prefer to not live in a jail like it was with Windows.
Any idea on how to manage Akonadi to freedom?
g

Hmm.. in KDE 4.7.2 I've found kjots keeps notes here: ~/.local/share/notes/new, It also saves some values in akonadi database, I managed to connect to it using mysql command.

Yes, you are right. But as I wrote in my first post, kjots can be found in
~/.local/share/notes/.pmgvvfOE2W.directory/hOoN8IsMgr/new/ (DOUBLE HIDDEN DIRECTORY !!!)
and stored in many files with name like "319372365.R125.VirteX"
This make impossible to copy a single "book" and put it in another machine.
I'll try to understand if the parent folder collect the pages of a single book, and I'll try to change the directory name from ".pmgvvfOE2W.directory" to something more easy to recognize. I'll do the same on the file having the same name of that directory.

OK, I found the key!!
The Akonadi Notes architecture is now clear to me.
Notes actually and physically live in ~/.local/share/notes directory.
Here you find your notes in a tree structure.
Each Notes conduit has a first level directory (i.e. 9xvv6tffs) where you find single pages in its "new" subdir.
In ".9xvv6tffs.directory" you find Books, arranged in a similar tree's structure: single pages live in "new" subdir, sub-books live in further ".subdir.directory" and so on.

The main problem was that migration tool gave complex names to books and sub-books, confusing the structure and making impossible to identify your books to copy.
But if you rename all your books FROM KJOTS ITSELF, the names are respected and the corresponding folders are then renamed in a human-readable way.
Try to do this renaming job and browse the ~/.local/share/note. Everything should become clear.
So you can copy a whole book or sub-book directory and put in another machine running kjots+Akonadi.

Hope it helps
giuliano