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

On 02/07/2014 08:40 AM, Andrew Douglas Pitonyak wrote:
> 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.
I think the other reason for using HSQL is it is easier to use as an 
embedded database while MySQL/MariaDB, PostgreSQL, etc. require the 
separate install of the database. The others are designed as stand-alone 
databases that one can connect to using a variety of tools.
> > 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)
Storing the link to the photo should make the database query run faster 
because the text string is orders of magnitude smaller than the photo. 
One problem is one must be very carefully about naming the photos.
> > Thanks for any help
> >
> > IanW
> > Pretoria RSA.

--
Jay Lozier
jslozier@gmail.com


--
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