On 02/07/2014 02:38 AM, Ian Whitfield wrote:
I've been using the Base/MySQL combination since mid-last year now and
it is fantastic!! It is much faster, never crashes or freezes and just
works the way it is supposed to. I can definitely recommend it to
anyone!! (In my opinion this should be the standard and HSQL should be
The advantage of HSQL is that it creates a single file and you do not
need to run a database daemon in the background (I am assuming that the
MySQL connector uses that rather than knowing how to read the MySQL
files directly). In other words, it does serve a need.
The disadvantage of HSQL, (speculation, so assume half of what I am
about to say is wrong) is that it sounds less stable, if you crash Base,
it is more likely to lose data, and everything stays in memory.
Now I have a couple of questions...
1) Where does MySQL store the Database? (I think it's in the root
Are you using Windows or Linux? Try looking under something like:
C:\Program Files\MySQL\MySQL Server #.#\my.ini
Look in that file for the basedir and datadir variables.
And now I see I need to run.
2) Is it easy to move it into the /home directory?
3) Where do I find the LO front-end form?
4) If I copy these two files to another machine will I be able to get
the Database running on this second machine?
I have a couple of graphics/photos in each record - Is it possible to
'Link' these instead of embedding them so that if you up-date a photo
it will automatically update in the Database? If this is possible will
it effect Base at all? (faster, slower etc)
Thanks for any help
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
To unsubscribe e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: 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