|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
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
|
|
|
|
Joined: Nov 2000
Posts: 210
Member
|
Member
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
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
Joined: Apr 2002
Posts: 1,768 |
Thanks The RESET MASTER command described on that page took care of it.
|
|
|
|
Joined: Nov 2000
Posts: 210
Member
|
Member
Joined: Nov 2000
Posts: 210 |
Your welcome
|
|
|
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.
|
|
Posts: 5,833
Joined: January 2000
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|