Binary logs are pretty important for backups as well. Most often people take a full backup using mysqldump or filesystem snapshots, and then back up their binlogs. With the full backup + all the binlogs since then, you can recover to any point in time you choose.
If you're not currently running replication then you don't really need those binlogs. Asking "will this be ok" is more a matter for you to decide in terms of your backup procedures. Once you start using replication, you only need to keep binlogs around as long as it takes your slaves to copy the data from the master; with a fast network that can be seconds. You can also use FLUSH LOGS; to force mysql to start a new binlog file, then purge all files before the most current one. Regards, Gavin Towey -----Original Message----- From: Steve Staples [mailto:sstap...@mnsi.net] Sent: Wednesday, January 06, 2010 11:43 AM To: mysql@lists.mysql.com Subject: RE: Binary Logging Silly me sees that there is an 'expire_log_days' in the my.cnf But again, if i was to purge everything but the last day or 2... running this command i found: PURGE BINARY LOGS BEFORE DATE_SUB(NOW(), INTERVAL 2 DAY); >From the MySQL command line, will this be ok? Steve. -----Original Message----- From: Steve Staples [mailto:sstap...@mnsi.net] Sent: January 6, 2010 2:35 PM To: mysql@lists.mysql.com Subject: Binary Logging Good afternoon. I am having a weird problem with the Binary Logging of my MySQL. For some reason, we have it on (still not sure why) but when i look in the /var/log/mysql/ folder, the oldest file is from the 2009-12-27. The MySQL service has not been restarted since the server came back up 150 days ago. So somehow, they have been purged in the past, but i don't see a cron that would have done it? Anyway, my question is, is that I am currently moving data around, splitting it into multiple tables, so there are TONNES of queries taking place, doing inserts and such, and now I am up to 93GB in this folder. I am starting to worry about running out of space on the harddrives, and we have been talking about doing a master/slave setup, and from what I've read, you need the binary logs on for replication? Is this true? Should I keep them, or can i ditch them, and will it re-create them when we do go to a master/slave setup? Once i finish moving data around, i can remove the old tables that i am moving them out of, so I don't really see a huge issue with dumping them, i just want to make sure. Thanks in advance! Steve Staples. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sstap...@mnsi.net No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.725 / Virus Database: 270.14.123/2592 - Release Date: 01/06/10 02:35:00 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=gto...@ffn.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you are notified that reviewing, disseminating, disclosing, copying or distributing this e-mail is strictly prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any loss or damage caused by viruses or errors or omissions in the contents of this message, which arise as a result of e-mail transmission. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089, USA, FriendFinder.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
