Previous Thread
Next Thread
Print Thread
Rate Thread
#231967 01/05/2003 4:15 PM
Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
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

Sponsored Links
joeuser #231968 01/05/2003 5:34 PM
Joined: Nov 2000
Posts: 210
Member
Member
Offline
Joined: Nov 2000
Posts: 210
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

MercAqua #231969 01/05/2003 5:41 PM
Joined: Apr 2002
Posts: 1,768
Addict
Addict
Offline
Joined: Apr 2002
Posts: 1,768
Thanks

The RESET MASTER command described on that page took care of it.

joeuser #231970 01/07/2003 2:03 PM
Joined: Nov 2000
Posts: 210
Member
Member
Offline
Joined: Nov 2000
Posts: 210
Your welcome


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)