mysqlbinlog

utility for processing binary log files

copy
245
0
mysqlbinlog binlog.[0-9]* | mysql -u root -p

source | details |

copy
26
0
mysqlbinlog binlog.000001 | mysql -u root -p # DANGER!!

source | details |

copy
12
0
mysqlbinlog binlog.0000003

source | details |

copy
8
0
mysqlbinlog binlog.000001 > /tmp/statements.sql

source | details |

copy
6
0
mysqlbinlog -vv log_file

source | details |

copy
6
0
mysqlbinlog --start-datetime="2005-12-25 11:25:56" binlog.000003

source | details |

copy
5
0
mysqlbinlog --hexdump master-bin.000001

source | details |

copy
4
0
mysqlbinlog -v --base64-output=DECODE-ROWS log_file

source | details |

copy
4
0
mysqlbinlog binlog.000001 | mysql -u root -p

source | details |

copy
3
0
mysqlbinlog log_file

source | details |

copy
3
0
mysqlbinlog binlog.000001 binlog.000002 | mysql -u root -p

source | details |

copy
3
0
mysqlbinlog binlog.000001 > tmpfile

source | details |

copy
2
0
mysqlbinlog -v log_file

source | details |

copy
2
0
mysqlbinlog binlog.000002 >> /tmp/statements.sql

source | details |

copy
2
0
mysqlbinlog --database=db2

source | details |

copy
2
0
mysqlbinlog --database=test

source | details |

copy
1
0
mysqlbinlog binlog.000002 | mysql -u root -p # DANGER!!

source | details |

copy
1
0
byte count for queries which do NOT contain the 'UPDATE cache' linemysqlbinlog mysql-bin.000099 | grep -iv 'update cache' | wc -c

4 years, 5 months ago ShahidMahmud 3 |

copy
0
1
queries have been logged to update the cache tables: mysqlbinlog mysql-bin.000099 | grep -ci 'update cache' find in mysql binary logs how many update queries were executed;

4 years, 5 months ago ShahidMahmud 3 |