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