UBB.Dev
Posted By: Dave_L_dup1 Big files - 01/05/2003 11:15 PM
In my MySQL directory, there are a number of large files. In the following directory listing, I've replaced my real domain name with "mydomain".

What's the correct method for getting rid of the large "-bin" files and the .log file? Do I just delete them, or would that mess up MySQL?

I tried doing a flush-logs with mysqladmin, but that didn't seem to have any effect.

-rw-rw---- 1 mysql mysql 86 Jan 4 2002 mydomain-bin.001
-rw-rw---- 1 mysql mysql 86 Jan 23 2002 mydomain-bin.002
-rw-rw---- 1 mysql mysql 86 Mär 20 2002 mydomain-bin.003
-rw-rw---- 1 mysql mysql 117 Apr 20 2002 mydomain-bin.004
-rw-rw---- 1 mysql mysql 86 Apr 20 2002 mydomain-bin.005
-rw-rw---- 1 mysql mysql 323 Apr 20 2002 mydomain-bin.006
-rw-rw---- 1 mysql mysql 51269964 Jul 2 2002 mydomain-bin.007
-rw-rw---- 1 mysql mysql 86 Jul 2 2002 mydomain-bin.008
-rw-rw---- 1 mysql mysql 86 Jul 2 2002 mydomain-bin.009
-rw-rw---- 1 mysql mysql 86 Jul 2 2002 mydomain-bin.010
-rw-rw---- 1 mysql mysql 5183 Jul 4 2002 mydomain-bin.011
-rw-rw---- 1 mysql mysql 564277629 Sep 18 16:22 mydomain-bin.012
-rw-rw---- 1 mysql mysql 68241893 Okt 19 23:07 mydomain-bin.013
-rw-rw---- 1 mysql mysql 86 Okt 19 23:20 mydomain-bin.014
-rw-rw---- 1 mysql mysql 124813747 Nov 28 07:21 mydomain-bin.015
-rw-rw---- 1 mysql mysql 113166331 Dez 4 10:16 mydomain-bin.016
-rw-rw---- 1 mysql mysql 1073741980 Dez 25 10:32 mydomain-bin.017
-rw-rw---- 1 mysql mysql 1073741980 Dez 28 18:11 mydomain-bin.018
-rw-rw---- 1 mysql mysql 866738883 Jan 4 22:58 mydomain-bin.019
-rw-rw---- 1 mysql mysql 699357 Jan 5 21:08 mydomain-bin.020
-rw-rw---- 1 mysql mysql 410837 Jan 5 22:09 mydomain-bin.021
-rw-rw---- 1 mysql mysql 441 Jan 5 21:08 mydomain-bin.index
-rw-rw-r-- 1 mysql root 3726 Jan 5 19:13 mydomain.err
-rw-rw---- 1 mysql mysql 340317322 Dez 4 05:08 mydomain.log
-rw-rw---- 1 mysql mysql 3 Jan 5 19:13 mydomain.pid
d
Posted By: Pappy Re: Big files - 01/06/2003 12:34 AM
those are from this http://www.mysql.com/doc/en/Binary_log.html I think?
[] To the binary log filename mysqld will append an extension that is a number that is incremented each time you execute mysqladmin refresh, execute mysqladmin flush-logs, execute the FLUSH LOGS statement or restart the server. A new binary log will also automatically be created when it reaches max_binlog_size. You can delete all not active binary log files with the RESET MASTER command. See section 4.5.4 RESET Syntax.

[/]
Pappy
Posted By: Dave_L_dup1 Re: Big files - 01/06/2003 12:41 AM
Thanks

The RESET MASTER command described on that page took care of it.
Posted By: Pappy Re: Big files - 01/07/2003 9:03 PM
Your welcome
© UBB.Developers