Thanks for the information. I'll have a try as soon as I migrate to 4.2.
Thanks also to Tom and Jay.
It seems that several good solutions are available for the backend db.
Paul Lens
Eau & Environnement
101, rue Haute
5060 Sambreville
BELGIQUE
Tel/fax: +32 (0)71/76.14.31
GSM: +32 (0)471/13.16.87
Le 7/02/2014 17:21, Alex Thurgood a écrit :
On 07/02/2014 08:38, Ian Whitfield wrote:
Hi Ian,
For some reason, your question shows up in Thunderbird in the thread
about Andropenoffice, hoping that you haven't hijacked it...
1) Where does MySQL store the Database? (I think it's in the root
somewhere)
It is usually (but not always) stored somewhere in /var on a Linux
system. On Ubuntu based systems, it seems to be located in "/var/lib/mysql"
2) Is it easy to move it into the /home directory?
If you know how to :
- change your my.cnf
- change the ownership and privileges of the new directory to correspond
to those of the user mysql process (i.e. the user that runs the mysqld
daemon)
3) Where do I find the LO front-end form?
In your ODB file. Unzip it and have a look, it'll be in there in a
subdirectory.
4) If I copy these two files to another machine will I be able to get
the Database running on this second machine?
No, mysql doesn't work as a single file that you just copy from one
place to another. It takes more work than that. Use a dump (sql file),
or setup the new mysql server on the second machine to be a replicant of
the first - this presupposes that the two machines can be connected
together over the internet or a local LAN, but if you have two machines
on the same subnet, better to just allow the second machine to access
your first machine's mysql server.
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)
Only possible with a macro that takes the location and name of the image
file stored in the database as a string, and then convert that to a link
for you on your form and provide some way of displaying it (e.g. shell
function to an outside viewer or loading the file into an image
control). Provided that you don't go and change the name of the file or
its location, the image will always be up to date even if you modify the
image itself.
Alex
--
To unsubscribe e-mail to: users+unsubscr...@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
