Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

You are right: because Base holds all the data in memory until shutdown, embedded HSQLDB databases can loss data if shutdown is not done correctly. MySQL keeps the data stored within its installed folder. Base connects to the MySQL server which accesses the data. The same thing is true for you favorite MySQL replacement (Mariadb).


On 10/18/2012 10:33 AM, Tom Davies wrote:
Hi :)
Dan, does that data-loss happen when you use MySql? I thought it only happened with the embedded HsqlDb?
Regards from
Tom :)

    *From:* Dan Lewis <>
    *Sent:* Thursday, 18 October 2012, 15:04
    *Subject:* Re: [libreoffice-users] Indexing for Search not working?

        As far as Base is concerned, I have not been having any
    problems with 3.4.6, 3.5.6, nor 3.6.2. (I just installed
    which is a release candidate. For my personal databases I use the
    most, I use MySQL as the backend with any of these LO Base
    versions as the front end. I work with Base for my
    writing. This database is embedded and contains only sample data
    (no important data contained in it). As far as JRE, I use 1.6.0_24
    (openjdk). LO seems to prefer this.
        I also use AOO 3.4.1 at times. It seems to prefer the Openjdk
        The main problem with Base is the potential for data loss when
    the program is not shutdown properly. This can be avoided by
    extracting the data from the database file and then use Base to
    connect to the data. (The data files are extracted to a separate
    folder.) Unfortunately, it does not improve the speed of Base.


    On 10/18/2012 07:15 AM, Pertti Rönnberg wrote:
    > Tom,
    > That info of yours is not only interesting but very important
    for me as an user - and most certainly for others too.
    > Unfortunately you add that "it is how you imagine it works"!
    > Would it be possible that you check that with the board or the
    devs themselves and then confirm it to us?
    > If I were you I definitely would like to be sure about the
    proceedings - (a) if such really has been settled or  (b) if not
    > Some posts ago I asked what version is for the time being
    considered the most reliable, especially regarding Base?
    > -- and what version of JRE is in that version needed for Base
    (if anymore needed)?
    > I have read the release notes and got an picture but what is
    your opinion?
    > My version now is LibO3.4.6 on Win7Pro/32 and Win7/64.
    > Pertti Rönnberg
    > On 18.10.2012 12:41, Tom Davies wrote:
    >> Hi :)
    >> The upgrade from 3.5.x to 3.5.7 is extremely unlikely to cause
    problems.  That 3rd digit is roughly like a "Service Pack" number,
    but divide it by 2 because MS only does 3 SPs whereas LO does 6 or 7.
    >> The 3.x.7 aims at avoiding introducing new features!  New
features are mostly in the 3.6.x or being lined-up for the 3.7.0. The 3.5.7 is likely to just have fixes for any lingering problems
    in the 3.5.6. Most of those fixes will be being merging into the
    3.6.3 and .4.  At least that's how i imagine it works. Certainly
    once that 3rd digit reaches .4 the branch seems a lot  more stable.
    >> Regards from
    >> Tom :)
    >> ________________________________
    >>> From: anne-ology < <>>
    >>> To: Dr. R. O Stapf <
    >>> Cc:
    >>> Sent: Thursday, 18 October 2012, 2:31
    >>> Subject: Re: [libreoffice-users] Indexing for Search not working?
    >>>        and now we're 3  :-)
    >>> On Wed, Oct 17, 2012 at 2:44 AM, Dr. R. O Stapf
    >>> <
    >>>> On 17.10.2012 16:07, Pertti Rönnberg wrote:
    >>>>> BRAVO Anne-Ology!!
    >>>>> Exactly that message - only in other words -- I have
    repeatedly tried to
    >>>>> tell to the LibO-experts (devs) since January:
    >>>>> they must take a brake in developing and take a certain
    version (e.g.
    >>>>> 3.4.xx) and make every module of the suite - Base included -
    >>>>> free of bugs and inconsistencies both in programming and the
    >>>>> and especially the LibO-Help.
    >>>>> Every feature shall have a clear explanation and a detailed
    >>>>> how-to in the LibO-Help -- easily understood by any average
    >>>>> user.
    >>>> I cannot agree more.
    >>>> I started with 3.5.4 a few month ago and saw some problems
    disappearing in
    >>>>    3.5.5 and 3.5.6. Currently I am hesitating to upgrade to
    >>>> I hope the dev-team listens to Pertti's words.
    >>> -- For unsubscribe instructions e-mail to: <>
    >>> Problems?
    >>> Posting guidelines + more:
    >>> List archive:
    >>> All messages sent to this list will be publicly archived and
    cannot be deleted

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.