billmax documentation   BillMax Billing Solutions
  877.245.5629
  sales@billmax.com
 
The MySQL log file
Prev  Chapter 4. Backing Up to Offline Storage  Next

The MySQL log file

In a typical BillMax installation, the MYSQLD_START setting in /usr/local/billmax/local/billmax.conf contains the "--log-update=`hostname`" option. This specifies a log file to which all database update transactions recorded. hostname is the name of the BillMax server. The resulting name of the log file is /usr/local/billmax/mysql/var/hostname.log. This log file may be compressed and renamed if MYSQLD_LOG_ROTATE_FREQUENCY is set to:

weekly

On Sundays, the existing log file is compressed and renamed using the current date in the new file name and ".gz" as the file type.

daily

Daily, the existing log file is compressed and renamed using the current date in the new file name and ".gz" as the file type.

Another parameter that affects the MySQL log files is the ISAM_ROTATE setting in /usr/local/billmax/local/billmax.conf. This setting is a numeric value that specifies the number of weeks to keep these log files.

Using either /usr/local/billmax/local/backup_hook or some other method, consider copying the files in /usr/local/billmax/mysql/var with a file type of ".gz" to offline storage.

Prev  Up  Next
Chapter 4. Backing Up to Offline Storage  Home  The DBLOG log file
Document Revision A for BillMax 2.2.0   -   Copyright © 1997-2006 The iSpark Group, Inc.

All rights reserved. No part of this documentation may be reproduced or transmitted in any fashion without written permission by The iSpark Group, Inc. This documentation is for the sole use of licensees of the BillMax billing software created by The iSpark Group, Inc. Making the documentation available to a non-licensee of BillMax without written permission of The iSpark Group, Inc. is a violation of the use of this documentation.

While precautions have been taken in the preparation of this documentation, The iSpark Group, Inc. assumes neither liability nor responsibility for errors or omissions, or for damages resulting from the use of the information contained herein.

All terms mentioned that are known to be trademarks have been appropriately capitalized. Use of the a trademark does not affect the validity of any trademark or service mark.

Links to third-party Web sites are provided for convenience. The iSpark Group, Inc. is not responsible for any content contained in the third-party Web sites.

Comments about this documentation may be sent to doc@billmax.com