Hi,
There is a thing I forgot to mention in my previous email - if you are
replicating your database please follow the steps described in
http://dev.mysql.com/doc/mysql/en/PURGE_MASTER_LOGS.html
or you might end with missing data on your slave servers. A binary log should
not be deleted
Here it is
#!/usr/bin/perl
use strict;
use DBI;
my $db_host=localhost;
my $db_user=username;
my $db_pass=password;
my $db_name=database;
my $mail_prog = '/usr/lib/sendmail';
my $email='[EMAIL PROTECTED]';
my $from_email='[EMAIL PROTECTED]';
sub mysql_die{
if ($_[0]){ print $_[0].\n;}
Many Thanks to Dobromir Velev,
And for those without PERL but with PHP (or prefer PHP) here is a quick and
dirty port to PHP
REMEMBER TO MAKE A BACKUP OF YOUR FILES BEFORE TESTING OR USING THIS
SCRIPT
IT IS RECOMMENDED YOU TEST THIS SCRIPT IN A NON PRODUCTION ENVIRONMENT
FIRST
Hi
I have a MySQL (mysql-standard-4.0.17-pc-linux-i686) running as master where I have
attached a slave to for replication. The problem now is that on the master there is a
LOT of mysql-bin.XXX files, and they each take 1GB diskplace.
Are these files needed still, or can i delete the old ones?
I've made a simple perl script that uses the
show master logs
and
purge master logs to 'mysql.???'
queries to remove all but the last seven logs and it works perfectly for me.
Check http://dev.mysql.com/doc/mysql/en/PURGE_MASTER_LOGS.html for details.
--
Dobromir Velev
[EMAIL PROTECTED]
On Thu, 10 Jun 2004 15:55:31 +0300
Dobromir Velev [EMAIL PROTECTED] wrote:
I've made a simple perl script that uses the
show master logs
and
purge master logs to 'mysql.???'
queries to remove all but the last seven logs and it works perfectly
for me.
Would you be willing to share
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 10 June 2004 08:03 am, Josh Trutwin wrote:
Would you be willing to share your perl script? Perhaps offlist if you are
concerned about everyone seeing it?
I would like to see it as well.. If at all possible
- --
How