On 02/07/2014 02:38 AM, Ian Whitfield wrote:
Hi All
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
dropped)
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
somewhere)
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?
Side question
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
IanW
Pretoria RSA.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php
--
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
