On Sat, 2012-03-17 at 20:20 +0000, Mark Stanton wrote:
I would suggest replacing the bastard (are we really talking like
this? :-) ) with MySQL or perhaps even better MariaDb (mebbe even
Postgres).
You can do this on Windows or Linux or even Mac (I imagine). Also
install phpMyAdmin (which also works with Maria I think) to give you
ease of access and control.
To make data security even better then perhaps something like
MySQLDumper to make regular backups would be good.
Then tell Base to talk to the database you've installed. Get your
data out of your backups and put it into the new database. Base may
make that really easy as, I think, you can have two Base databases,
one the old one the new, and drag tables across from the old to the
new (... but don't quote me on that).
From my experience this evening, I had to create a
"schema" (database) first. Then I gave myself as a user complete access
to the database (authority to execute all commands to it). After that, I
could drag and drop tables from an embedded database (Base) to the odb
file used to access MYSQL. Finally, when naming the table, it took the
format: "database"."table". Queries copied easily, but they needed to be
modified using SQL: all the FROM clauses required the same format for
the table names. Reports copied easily since they were based on queries
whose names I did not need to modify. Forms would not copy between
databases at all.
I use Ubuntu 11.10 which has MYSQL Administrator in its
repositories to handle administrative duties.
From the "using Base" end of things practically nothing will have
changed. Your forms, queries, reports, &tc will work just the same
way (once you've hooked them up to the new data in the new database),
but you'll have your data in a much more robust environment that you
can easily, regularly back up.
One observation: Using Base as the front-end greatly increased the
speed of changing records in the forms! This is nice!
--Dan
For this much installation and use you'll have very little new to
learn (phpMyAdmin makes it really simple, as does MySQLDumper).
There may be other things you'd like to delve into, but that's an
added bonus.
Regards
Mark Stanton
One small step for mankind...
--
For unsubscribe instructions e-mail to: users+help@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
Context
Re: [libreoffice-users] Re: Base and new Report Builder in 3.5 · Steven Shelton
[libreoffice-users] Re: Base and new Report Builder in 3.5 · frofa
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.