After you move/delete the file run 'mysqladmin flush-logs' and it will
recreate the file. Otherwise mysql will continue to write to the old
file handle even if it has moved to another file name or even stranger
has been deleted. You also will notice that until you let mysql close
the file you will not get your disk space back even though the files
still seems to be there.
Eric
On Wed, 5 Nov 2003, 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?
>
> Is this file necessary?
>
> Jim
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
(text/plain)