You need a where clause at the end to tell it which row to update.
[EMAIL PROTECTED] wrote:
>. mysqladmin version
>mysqladmin Ver 8.21 Distrib 3.23.42, for apple-darwin1.4 on powerpc
>Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
>This software comes with ABSOLUTELY NO WAR
Check in the slave's master.info file
In the first line you'll see a filename for the master's binary log an
in the second line you'll see the position.
Look at the file on the master server and compare the byte -size to the
position.
I wrote a little perl script/netsaint plugin that takes care
you can create my.cnf file with the contents
[mysqld]
socket=/var/lib/mysql/mysql.sock
and put it in path. In case you need to know where the my.cnf file should
be put, execute:
mysqld --help | grep my.cnf
or with your command line mysql binary do
mysql -uusername -p -S=/tmp/mysql.sock
--
/usr/local/bin/mysql -hhostname -uusername -ppassword -e "flush logs;"
Guy Davis wrote:
>Just wondering if any Linux users of MySQL out there had written a
>logrotate configuration file for dealing with MySQL binary logs on a
>replication Master.
>
>I want to rotate these logs (6.5 GB now) as so
