SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 08:14 AM
| ||||
| ||||
 -bin files in /var/lib/mysql-500 Hi! In my /var/lib/mysql-500 directory (that's where the database directories are), I've got files like this: -rw-rw---- 1 mysql mysql 70396545 Aug 12 18:40 hetzner-bin.000030 -rw-rw---- 1 mysql mysql 17952010 Aug 16 22:34 hetzner-bin.000031 -rw-rw---- 1 mysql mysql 261778556 Sep 23 21:47 hetzner-bin.000032 Those files are rather large. Do I need all those files? What do I need them for in the first place? Can I delete old files? Thanks, Alexander Skwar -- After all, all he did was string together a lot of old, well-known quotations. -- H.L. Mencken, on Shakespeare      |
|
02-28-2008, 08:14 AM
| |||
| |||
| Re: -bin files in /var/lib/mysql-500 Alexander Skwar wrote: > Do I need all those files? What do I need them for in the first > place? Can I delete old files? Yes, you can delete these, unless you need them for replication support or for data recovery. See http://dev.mysql.com/doc/refman/5.0/en/binary-log.html That page says: "You can delete all binary log files with the RESET MASTER statement, or a subset of them with PURGE MASTER LOGS." Regards, Bill K. |
|
02-28-2008, 08:14 AM
| ||||
| ||||
| Re: -bin files in /var/lib/mysql-500 ยท Bill Karwin <bill@karwin.com>: > Alexander Skwar wrote: >> Do I need all those files? What do I need them for in the first >> place? Can I delete old files? > > Yes, you can delete these, unless you need them for replication support > or for data recovery. See > http://dev.mysql.com/doc/refman/5.0/en/binary-log.html > > That page says: "You can delete all binary log files with the RESET > MASTER statement, or a subset of them with PURGE MASTER LOGS." Thanks, this helped! Alexander Skwar -- "...proper attention to Earthly needs of the poor, the depressed and the downtrodden, would naturally evolve from dynamic, articulate, spirited awareness of the great goals for Man and the society he conspired to erect." - David Baker, paraphrasing Harold Urey, in "The History of Manned Space Flight" |
 |
« Clear MySQL History - Remotely
|
How can I make mysqld find the table 'mysql.host' on Fedora Core 4? »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 04:39 AM.
