Re: [libreoffice-users] Urgent Base problem

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