[libreoffice-users] Re: Base Compact and Shutdown

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

Hi Ian,

> 'SHUTDOWN COMPACT'

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. OpenOffice.org,
LibreOffice, ApacheOpenOffice, NeoOffice.


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