Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Hello Pertti,
Just for "kicks": I used to personally know some of the "old" IBMers who
actually "invented" SQL, in particular DB2. That's a long time ago though...
I have LO running on Linux-Debian, Linux-Mint, and Windows/Vista (32 Bit).
The MySQL server runs on Linux, the clients run on all of these systems
(locally and LAN- or broadband-Internet-attached).
As I mentioned before, I have taken to using the native MySQL connector
preferably. It is faster and in my view somewhat less "buggy". Besides,
I keep reading in the mail lists that LO intends to "minimise" the
dependence on Java. The native connector comes included in the Windows-LO
version as far as I remember. So all you have to do is define your connection
for it (connect to a MySQL-database and then specify that you want to use the
native connector (the other possibilities on the respective dialog box being
The LO-Base definitions on the client side are basically the same as for the
Linux-version. I used to run the MySQL server also on Windows but have not done
so for a long time. If I remember correctly, my.cnf is called my.ini (or maybe
mysql.ini) in "true" Windows fashion. Again, the definitions in that file
should not be THAT different from the Linux situation (except - maybe -
the stuff concerning sockets/pipes).
Regards from Austria

On Tue, 06 Nov 2012 10:34:10 +0100, Pertti Rönneberg <> wrote:

Hello LibO experts,
and congratulations IanW!

It has been very interesting to follow this discussion getting Base
working with MySQL.
Unfortunately -- if I got it right - is Ian's OS a Linux (Ubuntu?)

Would it be possible to get the same proceeding described as a
step-by-step instruction for Windows7 (64bit)?
 >    in plain english  (no IT-jargong)
 >    starting from the very beginning defining the different programs
(versions) and components (ODBC, JDBC, JRE, etc when needed, included)
to be installed

Since Andreas Säger (one of LibO db-experts) last winter and spring
repeatedly pointed out that LibO/Base is not to be considered as a
stand-alone database program I have several times tried to create the
connection LibO/Base to SQLite and to MySQL (I prefer SQLite as lighter
than MySQL), but without success.

I am sure that such an instruction could increase the acceptance and
usability of LibO and
I am sure that we are many that would be happy.
Pertti Rönnberg

On 6.11.2012 9:54, Steve Edmonds wrote:

On 2012-11-06 20:41, Ian Whitfield wrote:
Thanks Guys!! (Girvin, Henirich, Dan, Mas and maybe others!!)

You have all added some pieces to the Jigsaw and I'm pleased to

*I now have Base working with a MySQL Database!!!! (at last!!)*

As Girvin would say "My Bad"!! I had been looking for the file
'my.cfg' when it should have been 'my.cnf'. This was the last missing
piece, once I found it and found the "skip-networking" line inside it
and commented it out everything worked fine.

So once again guys - thanks for sticking with me - awesome support
and I do appreciate it!!

Now the fun starts - I have already designed my Form yesterday but
now need to puzzle out how to get all my data out of the old DB into
the new SQL DB. And then re-write all my Queries and reports.

Greatly appreciated - regards from South Africa

Pretoria RSA.

If you can get your data out of the old database as a csv file it is
real easy to load into MySQL.
You can use the command line MySQL command or if you install webmin it
makes database admin easy.

Erstellt mit Operas revolutionärem E-Mail-Modul:

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.