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


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


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.