Re: [vchkpw] Files belong to vpop?
Those look like MySQL binary files. Run this and see if some go away: /usr/local/bin/mysql -uroot -p -ePURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 10 day); Rick On Tue, 2008-06-03 at 14:59 -0400, m c wrote: Hello. I am dealing with a FreeBSD box that I inherited from another admin. The box is used for vpopmail and some tftp services. I'm trying to relive some space issues on /var. I've run come across several large files (see below) that seem to be used by vpopmail but I haven't been able to find any information about their use. The files are: tftp-bin.index tftp-bin.001 tftp-bin.002 tftp-bin.003 tftp-bin.004 tftp-bin.005 tftp-bin.006 tftp-bin.007 The content looks like this: E8EA9A[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@replace into dir_control ( domain, cur_users, level_cur, level_max, level_start0, level_start1, level_start2, level_end0, level_end1, level_end2, level_mod0, level_mod1, level_mod2, level_index0, level_index1, level_index2, the_dir ) values ( 'wxyz.com', 286, 0, 3, 0, 0, 0, 61, 61, 61, 0, 2, 4, 1, 0, 0, '1') There is only one file currently updating (tftp-bin.007). The others have last update dates that are older than 1yr, yet some of the files are 20M+. For this reason I was hoping to clean some of these up but I'm unsure if I can do that without effecting the system. Thanks. !DSPAM:484595d332351275215509!
[vchkpw] Files belong to vpop?
Hello. I am dealing with a FreeBSD box that I inherited from another admin. The box is used for vpopmail and some tftp services. I'm trying to relive some space issues on /var. I've run come across several large files (see below) that seem to be used by vpopmail but I haven't been able to find any information about their use. The files are: tftp-bin.index tftp-bin.001 tftp-bin.002 tftp-bin.003 tftp-bin.004 tftp-bin.005 tftp-bin.006 tftp-bin.007 The content looks like this: E8EA9A[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@replace into dir_control ( domain, cur_users, level_cur, level_max, level_start0, level_start1, level_start2, level_end0, level_end1, level_end2, level_mod0, level_mod1, level_mod2, level_index0, level_index1, level_index2, the_dir ) values ( 'wxyz.com', 286, 0, 3, 0, 0, 0, 61, 61, 61, 0, 2, 4, 1, 0, 0, '1') There is only one file currently updating (tftp-bin.007). The others have last update dates that are older than 1yr, yet some of the files are 20M+. For this reason I was hoping to clean some of these up but I'm unsure if I can do that without effecting the system. Thanks. !DSPAM:4845948332359587726927!
Re: [vchkpw] Files belong to vpop?
mysql binary logging I use it for replication Thanks, Richard On Jun 3, 2008, at 2:59 PM, m c wrote: Hello. I am dealing with a FreeBSD box that I inherited from another admin. The box is used for vpopmail and some tftp services. I'm trying to relive some space issues on /var. I've run come across several large files (see below) that seem to be used by vpopmail but I haven't been able to find any information about their use. The files are: tftp-bin.index tftp-bin.001 tftp-bin.002 tftp-bin.003 tftp-bin.004 tftp-bin.005 tftp-bin.006 tftp-bin.007 The content looks like this: E8EA9A[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@replace into dir_control ( domain, cur_users, level_cur, level_max, level_start0, level_start1, level_start2, level_end0, level_end1, level_end2, level_mod0, level_mod1, level_mod2, level_index0, level_index1, level_index2, the_dir ) values ( 'wxyz.com', 286, 0, 3, 0, 0, 0, 61, 61, 61, 0, 2, 4, 1, 0, 0, '1') There is only one file currently updating (tftp-bin.007). The others have last update dates that are older than 1yr, yet some of the files are 20M+. For this reason I was hoping to clean some of these up but I'm unsure if I can do that without effecting the system. Thanks. !DSPAM:4845993032353381934755!
Re: [vchkpw] Files belong to vpop?
On Jun 3, 2008, at 2:59 PM, m c wrote: Hello. I am dealing with a FreeBSD box that I inherited from another admin. The box is used for vpopmail and some tftp services. I'm trying to relive some space issues on /var. I've run come across several large files (see below) that seem to be used by vpopmail but I haven't been able to find any information about their use. The files are: tftp-bin.index tftp-bin.001 tftp-bin.002 tftp-bin.003 tftp-bin.004 tftp-bin.005 tftp-bin.006 tftp-bin.007 Yep. MySQL logs. You should look into creating some sort of cron job that will automate the elimination of those logs, after suitable backup of course. That can be tricky if you don't know how MySQL works though. !DSPAM:48459aac32351316918311!
Re: [vchkpw] Files belong to vpop?
Rick, Thanks a ton for the help. Had to use: PURGE MASTER LOGS TO 'tftp-bin.007'; System didn't like the BEFORE syntax even when using a static date, but your reply gave me some direction and this worked just as well for me. M On Tue, Jun 3, 2008 at 3:04 PM, Rick Romero [EMAIL PROTECTED] wrote: Those look like MySQL binary files. Run this and see if some go away: /usr/local/bin/mysql -uroot -p -ePURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 10 day); Rick On Tue, 2008-06-03 at 14:59 -0400, m c wrote: Hello. I am dealing with a FreeBSD box that I inherited from another admin. The box is used for vpopmail and some tftp services. I'm trying to relive some space issues on /var. I've run come across several large files (see below) that seem to be used by vpopmail but I haven't been able to find any information about their use. The files are: tftp-bin.index tftp-bin.001 tftp-bin.002 tftp-bin.003 tftp-bin.004 tftp-bin.005 tftp-bin.006 tftp-bin.007 The content looks like this: E8EA9A[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@replace into dir_control ( domain, cur_users, level_cur, level_max, level_start0, level_start1, level_start2, level_end0, level_end1, level_end2, level_mod0, level_mod1, level_mod2, level_index0, level_index1, level_index2, the_dir ) values ( 'wxyz.com', 286, 0, 3, 0, 0, 0, 61, 61, 61, 0, 2, 4, 1, 0, 0, '1') There is only one file currently updating (tftp-bin.007). The others have last update dates that are older than 1yr, yet some of the files are 20M+. For this reason I was hoping to clean some of these up but I'm unsure if I can do that without effecting the system. Thanks. !DSPAM:4845bb0c32355712019436!
