Hi anyone _EVER_ able to get mysqlbinlog to remotely read a server's binlog?
I have read http://dev.mysql.com/doc/refman/5.0/en/mysqlbinlog.html
and the command I use is:
mysqlbinlog --read-from-remote-server --database=mydbname --start-datetime="2008-06-
11 00:00:00" --stop-datetime="2008-06-1
6 23:59:59" -hremotehost -umyusername -pmypassword -rmyresult.txt
remote host running default 3306.
and if I ssh to the server then I can read it successfully for that time period, by specifying the path & name of input binlogs.
however it did not give me result, but poping me the manpage of mysqlbinlog.
It looks like the format I am using is wrong womewhere.
Do I need to specify binlog path when reading remotely? --I don't think it makes sense in this way.
so where is wrong?