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

On 12/30/2012 10:11 AM, Ian Whitfield wrote:

Hi Ian,


This command is only of any use with regard to the "embedded" HSQLDB
database that is held within an ODB native database file. If you are
accessing an external database engine, as in your current case with a
mysql server, it is unnecessary and irrelevant. Mysql databases rarely,
in my own experience, become corrupt - yes, it can happen, but I've only
ever had it happen to me once, even through various "crash and burn"
cycles of hard disks, network cards, servers and other computer
equipment over the space of 7 years or so that I have been using them.

The ODB file that contains your forms, queries, reports, does not
permanently store table data - this is stored on the mysql server. If
you want to carry out mysql admin tasks on your server, then I suggest
you either look up the mysqladmin command line utility or its graphical
equivalent which you can obtain from the mysql website, or possibly even
from within your own distros packages.

There is AFAIK unfortunately no command that will maintain the integrity
of your ODB files (or any other ODF formatted file for that matter),
this is dependent on the implementation of the software that you are
using to read and write to your ODB file, i.e.,
LibreOffice, ApacheOpenOffice, NeoOffice.


For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.