Hi, If you upgrade to the latest version, ‘compact database’ has an option to archive the old logs, which would have achieved the same thing, but without data loss ☺
Cheers, Peter From: [email protected] [mailto:[email protected]] On Behalf Of Pete Kovalenko Sent: 30 March 2017 07:06 To: mnemosyne-proj-users <[email protected]> Subject: [mnemosyne-proj-users] Re: Trouble with importing *.db files I opened the .db file in SQLite Manager and deleted the entire contents of the "log" table. I no longer have the past statistics, but at least the .db file is small again. Problem solved. On Thursday, March 30, 2017 at 6:50:34 AM UTC+3, Pete Kovalenko wrote: My problem: after importing "Mnemosyne 2.x *.db files" only active cards of the source .db are imported (which is nice), nevertheless the destination .db bloats enormously, as if the entire source .db was imported. I merged my own .db and my daughter's .db into one file so we now do our repetitions together, which is fun. But I kept adding new cards to my old .db in order to get them a little more mature, to correct mistakes, to add sounds/pictures/videos etc before transferring them to our main .db file. I was adding ≈200 new cards a week. Did it weekly for 3 or 4 weeks and noticed that Mnemosyne became real slow for some reason. Checked the .db file, and it was huge -- 133 Mb. "Compact Database" command didn't do much. For the sake of experiment I left only 2 cards active (out of more than 19000) and imported this huge .db into my old personal .db -- and now its size is 137 Mb (with only 55 cards in it). What should I do? ("Compact Database" command doesn't do much to the size of these files.) (my Mnemosyne version is 2.3.5) -- You received this message because you are subscribed to the Google Groups "mnemosyne-proj-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To post to this group, send email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/mnemosyne-proj-users/487c88d0-cd27-4c44-befb-5cfd98519754%40googlegroups.com<https://groups.google.com/d/msgid/mnemosyne-proj-users/487c88d0-cd27-4c44-befb-5cfd98519754%40googlegroups.com?utm_medium=email&utm_source=footer>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "mnemosyne-proj-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/mnemosyne-proj-users/b0dceb1834264d87b639519ff3f3be68%40xmail101.UGent.be. For more options, visit https://groups.google.com/d/optout.
