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