dbTalk Databases Forums  

Binary logs of MySQL

comp.databases.mysql comp.databases.mysql


Discuss Binary logs of MySQL in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Peter Jespersen
 
Posts: n/a

Default Binary logs of MySQL - 04-21-2011 , 06:20 AM






Hello

I've got a small home server, that hosts a few web pages on a few domains -
a couple of WP and a Drupal based - all of which is using MySQL.

Recently I've run into some issues regarding the amount of free space on my
server disks. After some snooping around, I've found a bunch of MySQL-bin
files approx 3Gigs worth.

A quick investegation reveals that it is binary logfiles containing every
change to the system.

Since it isn't really a system that is a question of national security I
figure that the dump that is created every night by a cron job should be
sufficient for recreating the contents of the databases.

In short : Is it safe to just delete the binary logs ?

Many thanks

--
Live long and prosper...
Peter Jespersen

Reply With Quote
  #2  
Old   
Axel Schwenke
 
Posts: n/a

Default Re: Binary logs of MySQL - 04-21-2011 , 06:31 AM






Peter Jespersen <flywheel (AT) illogical (DOT) dk> wrote:

Quote:
Recently I've run into some issues regarding the amount of free space on my
server disks. After some snooping around, I've found a bunch of MySQL-bin
files approx 3Gigs worth.
....

Quote:
In short : Is it safe to just delete the binary logs ?
Don't delete them manually. There is a PURGE BINARY LOGS statement.
Also you should RTFM how to disable binlogging. Or have old binlogs
deleted automatically.

http://dev.mysql.com/doc/refman/5.1/...pire_logs_days
http://dev.mysql.com/doc/refman/5.1/...nary-logs.html


XL

Reply With Quote
  #3  
Old   
Peter Jespersen
 
Posts: n/a

Default Re: Binary logs of MySQL - 04-21-2011 , 07:02 AM



Axel Schwenke wrote:

Quote:
Peter Jespersen <flywheel (AT) illogical (DOT) dk> wrote:

Recently I've run into some issues regarding the amount of free space on
my server disks. After some snooping around, I've found a bunch of
MySQL-bin files approx 3Gigs worth.

...

In short : Is it safe to just delete the binary logs ?

Don't delete them manually. There is a PURGE BINARY LOGS statement.
Also you should RTFM how to disable binlogging. Or have old binlogs
deleted automatically.

http://dev.mysql.com/doc/refman/5.1/en/server-system-
variables.html#sysvar_expire_logs_days
http://dev.mysql.com/doc/refman/5.1/...nary-logs.html
Great thanks, all I wanted to know


--
Live long and prosper...

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.