4번독수리의 둥지

get MySQL binlog as SQL 본문

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

'Database > MySQL' 카테고리의 다른 글

SQL JOIN  (0) 2016.02.24
Select tables optimized away  (0) 2015.10.23
Correct indexing when using OR operator  (0) 2015.09.08
mysql prepared statement  (0) 2014.10.21
mysql use database vs database.table  (0) 2014.10.21