[libreoffice-users] Re: Re-Connecting LO Base to an SQL DB

Le 23/02/2013 11:56, Ian Whitfield a écrit :

Hi Ian,

> I have accepted what has happened and am busy re-building my DB from
> scratch! IMHO it is still WRONG to store Data in an area that gets
> overwritten every time you do a upgrade or re-install. In over 30 years

Usually, an simple upgrade of mysql will not overwrite your tables.
Sometimes, it will create a new data directory, and keep your previous
data in an old/renamed directory (e.g. migrated, or "old", or even
tagged with the previous version number) - this is what happens on OSX,
for example. However, what happens exactly is very dependent on the
Linux distribution's version of mysql that they happen to have modified
to suit their system. Each distro tends to do its own thing, which can
be immensely frustrating. Debian based distros like Ubuntu/Mint and
consorts tend to use debconf, with which, personally, I still have
rather a hard time. PCLinuxOS used to be Mandrake based, but I'm not so
sure now. I imagine that RedHat and Suse have yet another mechanism for
auto-configuring the setup and migration of mysql data when upgrading
versions. So, as usual with many things Linux, YMMV, which as a casual
user can be a right, royal PITA.


If, however, you do a fresh install of your operating system, well,
then, I would say that it is to be expected that your data on the root
drive gets wiped. There are various ways to mitigate this, including
having separate partitions for /(root), /usr (for most graphical
applications and their basic configuration data), /var (for stuff like
mailserver and database data) and /home (for users' data and
configuration files), but most distributions do not offer that in the
simplified installation routine, where everything tends to get installed
into a single /(root) partition. If you keep things separate as
indicated above, you can even re-install your OS (up to a certain
extent, at least) without trashing your /home or other sensitive or
important data areas.


Anyway, enough of the preaching, you live and learn as they say, I know
I certainly did, but it did involve frequent hair pulling at times !!


Alex




-- 
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