Re: [libreoffice-users] LO Base/MySQL questions

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: users+unsubscribe@global.libreoffice.org
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