Hi :) This mailing list might be able to help you migrate your existing tables to an external back-end. There was a looong thread about this a few years ago when Ian (err can't remember his surname [hangs head in shame]). It is roughly what i hope to do = start with the internal back-end and then migrate it.
To be fair it's not Hsql that is the problem. It's the ancient version that got twisted and squeezed into being the internal back-end in Base and then didn't get enough further developments. As an external back-end, if you grab any of their newer versions straight from their website, then it apparently works like a dream (errr as in super fast and smooth, not as in imaginary). On the other hand it might be good to choose a different back-end and there are plenty to choose from. When choosing a back-end it might be worth considering what sort of size are you talking about. MySql/MariaDb, Postgresql and other big names are meant for huge amounts of data. I mean really vast and quite complex. For an address book for a small-medium sized business it's over kill and you might find them comparatively sluggish when handling that little data. What i need is something small and fast but that often points to java-based ones such as Hsql and java makes me shudder. Regards from Tom :) On 16 January 2014 01:19, Vince Radice <[email protected]> wrote: > Unfortunately, I don't know what causes the problem and, thus, I can't > recreate it. > > I am trying something now. I brought it up, updated a record but did not > save it (I have a saved copy someplace else). I intend to let it be up > overnight and check in the morning for the files. I had already cleared out > all of the empty ones. I noted the time I brought is up and made the > change. > > I want to see if it reoccurs. if so, then when. I also intend to save it > and close it in the morning. If the files are there, see if the creation > stops. Hopefully, this will lead to why it is happening. > > > On another tangent, I had lost data and had to recreate the db. During that > process, I read a few things indicating that using HSQL could lead to losing > data. The recommendation was to use an external db. I spent several weeks > last year trying to get Mysql to work. I followed the conversion guidelines > that I had found but was unable to get it to work. I created the Mysql > database and was able to create and load the tables (I think) but I could > never get Base to recognize and use it. All of my queries and reports are > in Base. I may have to try again if I can find the time. This time I will > record what I install and what I do. > > Vince Radice > > On 01/15/2014 11:46 AM, Alex Kempshall wrote: >> >> Having said all that. It would appear that I've never had auto backup >> switched on. >> >> Having switched it on I now see backups and autobackups for writer and >> calc documents. Nothing at all for base documents. >> >> Alex >> >> >> >> On Wednesday 15 Jan 2014 14:35:33 Alex McMurchy wrote: >>> >>> I used to have that problem. It seems to have stopped around about 16th >>> July 2013. Not sure why! >>> >>> Either - >>> >>> I upgraded LibreOffice which stopped the feature >>> or I did something else which I can't remember! >>> >>> I'm currently on 4.1.4.2. >>> >>> Alex >>> >>> >>> >>> >>> On Wednesday 15 Jan 2014 07:38:25 Tom Davies wrote: >>>> >>>> Hi :) >>>> Errr, is it possible to switch the auto-save and auto-backups off for >>>> a while and see if that improves things? The thing i find difficult >>>> about doing that is remembering to save properly and frequently >>>> enough. With Base i think it's also important to close properly. >>>> >>>> There is some documentation and a handbook at >>>> https://wiki.documentfoundation.org/Documentation/Publications >>>> and the Faq at >>>> https://wiki.documentfoundation.org/Faq >>>> might be able to help too but the best place seems to be this mailing >>>> list or the Base forums at Apache OpenOffice. >>>> Regards from >>>> Tom :) >>>> >>>> On 15 January 2014 07:30, Tom Davies <[email protected]> wrote: >>>>> >>>>> Hi :) >>>>> Errr, are you using the internal back-end? You haven't connected to >>>>> an external back-end have you? You should really be keeping your data >>>>> in an external back-end instead of having the whole database as a >>>>> single file. >>>>> >>>>> Being able to do that is one of the main things that makes Base so >>>>> much more powerful than Access. The internal back-end got tacked on >>>>> to make Base more familiar to people who have picked up bad habits by >>>>> using Access. It seems to be a bit broken though. Annoyingly the >>>>> Marketing Mailing List and all our flyers, posters and leaflets (at >>>>> least all the ones that mention Base at all) keep pushing people into >>>>> using the internal back-end despite the fact that users have even >>>>> experienced data-loss by doing so. I'm tempted to ask you to take >>>>> this problem to the marketing list to get them to solve it but the >>>>> experts in Base are mostly on this list and will hopefully be able to >>>>> help with this issue. >>>>> >>>>> It should be possible to export your existing tables into an external >>>>> back-end and this mailing list (note, not the marketing list) might be >>>>> able to help you with that. >>>>> >>>>> The next smart thing about Base is that forms and reports can be, and >>>>> are best made in Writer or/and (i think) Calc. So normal users who >>>>> are clueless about databases can read the data in a familiar setting >>>>> and use familiar tools to format and edit things around the >>>>> data-fields. The forms and reports inside Base seem to be for >>>>> data-entry and people who have some clue about databases. >>>>> >>>>> However i have never quite got around to getting to grips with all >>>>> this. So hopefully some of the experts might wade in and set me >>>>> straight (again) >>>>> Regards from >>>>> Tom :) >>>>> >>>>> >>>>> >>>>> >>>>> On 15 January 2014 05:57, Vince Radice <[email protected]> wrote: >>>>>> >>>>>> I am running Fedora FC19-64 bit. Libreoffice Version: 4.1.4.2 >>>>>> Build ID: 4.1.4.2-2.fc19 >>>>>> >>>>>> Here are some lines of a ls -la command >>>>>> >>>>>> -rw-------. 1 vince root 0 Dec 13 13:10 GRNew odb_0.odb >>>>>> -rw-------. 1 vince root 0 Dec 13 15:58 GRNew odb_1000.odb >>>>>> -rw-------. 1 vince root 0 Dec 13 15:58 GRNew odb_1001.odb >>>>>> -rw-------. 1 vince root 0 Dec 13 15:58 GRNew odb_1002.odb >>>>>> -rw-------. 1 vince root 0 Dec 13 15:58 GRNew odb_1003.odb >>>>>> -rw-------. 1 vince root 0 Dec 13 15:58 GRNew odb_1004.odb >>>>>> -rw-------. 1 vince root 0 Dec 13 15:58 GRNew odb_1005.odb >>>>>> -rw-------. 1 vince root 0 Dec 13 15:59 GRNew odb_1006.odb >>>>>> -rw-------. 1 vince root 0 Dec 13 15:59 GRNew odb_1007.odb >>>>>> -rw-------. 1 vince root 0 Dec 13 15:59 GRNew odb_1008.odb >>>>>> -rw-------. 1 vince root 0 Dec 13 15:59 GRNew odb_1009.odb >>>>>> -rw-------. 1 vince root 0 Dec 13 13:26 GRNew odb_100.odb >>>>>> -rw-------. 1 vince root 0 Dec 13 15:59 GRNew odb_1010.odb >>>>>> >>>>>> My database name is GRNew,odb. >>>>>> I was looking at some of the recent messages that were talking about >>>>>> LO >>>>>> looping saving backups of untitled documents. It mentioned Calc and >>>>>> Write >>>>>> as being involved. Could this be related to my problem? >>>>>> >>>>>> Thanks, >>>>>> Vince Radice >>>>>> >>>>>> >>>>>> On 01/14/2014 12:44 PM, Tom Davies wrote: >>>>>>> >>>>>>> Hi :) >>>>>>> On Ubuntu 12.04 i have no files in there. Do the file-names start >>>>>>> with a ~ or with "lock"? In either of those cases i think you can >>>>>>> delete the files without worry but it might be worth testing that for >>>>>>> 1 or 2 files. >>>>>>> >>>>>>> Going off on a tangent i do have a non-LibreOffice folder with a load >>>>>>> of crash reports from when i don't close Xbmc properly and i >>>>>>> routinely >>>>>>> delete all of them from time-to-time. I'm not sure if this is >>>>>>> similar >>>>>>> or not. >>>>>>> Regards from >>>>>>> Tom :) >>>>>>> >>>>>>> >>>>>>> On 14 January 2014 04:12, Vince Radice <[email protected]> wrote: >>>>>>>> >>>>>>>> I am seeing something and I don't know if it is a problem or >>>>>>>> something I >>>>>>>> have to live with. >>>>>>>> >>>>>>>> In the ~/.config/libreoffice/4/user/backup directory, I have 3,000+ >>>>>>>> files >>>>>>>> with 0 bytes. I assume that this means the files are empty. There >>>>>>>> are >>>>>>>> other >>>>>>>> files there which are not empty. The non-empty ones appear to be >>>>>>>> backups >>>>>>>> of >>>>>>>> files I have worked on. The empty files all appear to be attempts >>>>>>>> to >>>>>>>> backup >>>>>>>> a Base database that I have created using the built in hsql engine. >>>>>>>> The >>>>>>>> file is stored on my computer. The time stamps on the files are >>>>>>>> unusual. >>>>>>>> There are 6 files with a time stamp of 15:58, 6 with 15:59, 6 with >>>>>>>> 16:00 >>>>>>>> and >>>>>>>> the pattern continues for the other 3,500 empty files. >>>>>>>> >>>>>>>> Does any one else have the same situation? I have the save/backup >>>>>>>> time >>>>>>>> in >>>>>>>> the general options set to 15 minutes. >>>>>>>> >>>>>>>> I have a listing of all of the files if anyone wants to see it. >>>>>>>> >>>>>>>> Thank you, >>>>>>>> Vince Radice >>>>>>>> >>>>>>>> -- >>>>>>>> To unsubscribe e-mail to: [email protected] >>>>>>>> Problems? >>>>>>>> >>>>>>>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >>>>>>>> Posting guidelines + more: >>>>>>>> http://wiki.documentfoundation.org/Netiquette >>>>>>>> List archive: http://listarchives.libreoffice.org/global/users/ >>>>>>>> All messages sent to this list will be publicly archived and cannot >>>>>>>> be >>>>>>>> deleted >>>>>>>> >>>> >>> > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
