[google-cloud-sql-discuss] error accessing the raw binlog files

Hi,

I am trying to access the binary log files of a cloud sql instance using mysqlbinlog. I used the following command from a GCE vm which has access to the cloud sql instance:
$ mysqlbinlog --read-from-remote-server --host=xxx --user=xxx --password=xxx mysql-bin.00pqrs

but getting the following error from the above command :
ERROR: Got error reading packet from server: Binary log is not open

Any idea what might be going wrong? I have confirmed the following cases: 

- Binary logs are already enabled on this server and there is a working read-replica of this instance.

- queries are running fine from this GCE vm using the mysql client.

- the mysql user already have 'REPLICATION SLAVE' privilege

- Accessing any binlog file from the output of 'SHOW BINARY LOGS' gives the same error. 

I am also wondering what are the alternate ways to access the raw binlog files? Is there a simple way to just export these to cloud storage?

Thanks,
Amit

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/89ee4c65-f769-4276-aa8b-ba4665f534c5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.