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: [email protected]
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
