mysqlbinlog : Can't create/write to file '/tmp/' (Errcode: 21)

Question

尝试从我的 mysql 服务器实例 (RDS) 下载二进制日志时出现此错误，命令是:

mysqlbinlog --read-from-remote-server --host=my.server.rds.amazonaws.com --port=3306  --user foo --password --result-file=/tmp/ mysql-bin-changelog.164974

Answer 1

来自manual (或 man mysqlbinlog):

--result-file=name, -r name

Without the --raw option, this option indicates the file to which mysqlbinlog writes text output. With --raw, mysqlbinlog writes one binary output file for each log file transferred from the server, writing them by default in the current directory using the same names as the original log file. In this case, the --result-file option value is treated as a prefix that modifies output file names.

所以你应该添加一个文件名，例如out.txt:

mysqlbinlog --read-from-remote-server --host=my.server.rds.amazonaws.com --port=3306  --user foo --password --result-file=/tmp/out.txt mysql-bin-changelog.164974