Database/MySQL

get MySQL binlog as SQL

4번독수리 2015. 7. 20. 16:18

lsof -nc mysqld | grep index

mysqlbinlog bin_log_file_name > sql_file_name

 

http://www.psce.com/blog/2012/06/02/how-to-find-mysql-binary-logs-error-logs-temporary-files/

https://dev.mysql.com/doc/refman/5.0/en/mysqlbinlog.html