mysql.log

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Mike Starke
Date:  
Subject: mysql.log
On Wed, Nov 05, 2003 at 04:41:44PM -0700, Jim wrote:
/_In /var/log I have a file that is 1.9G it is mysql.log can I delete this
/_file and it will be recreated?
/_

You probably have al your SQL queries logged with a file that size.
By deleteing, you could not "replay" that log file in a recovery
situation.

I would backup the database, then delete the file. There are a lot
of "depends" situations to consider tho'. Personal use, backup all db's
and delete.

-mike