mysqlbinlog

matumizi kwa ajili ya usindikaji files logi binary

nakala
246
0
mysqlbinlog binlog.[0-9]* | mysql -u root -p

chanzo | maelezo |

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

chanzo | maelezo |

nakala
12
0
mysqlbinlog binlog.0000003

chanzo | maelezo |

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

chanzo | maelezo |

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

chanzo | maelezo |

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

chanzo | maelezo |

nakala
6
0
mysqlbinlog -vv log_file

chanzo | maelezo |

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

chanzo | maelezo |

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

chanzo | maelezo |

nakala
3
0
mysqlbinlog log_file

chanzo | maelezo |

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

chanzo | maelezo |

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

chanzo | maelezo |

nakala
2
0
mysqlbinlog -v log_file

chanzo | maelezo |

nakala
3
0
mysqlbinlog binlog.000001 > tmpfile

chanzo | maelezo |

nakala
2
0
mysqlbinlog --database=db2

chanzo | maelezo |

nakala
2
0
mysqlbinlog --database=test

chanzo | maelezo |

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

chanzo | maelezo |

nakala
1
0
mysqlbinlog mysql-bin.000099 | grep -iv 'update cache' | wc -c

6 miaka, miezi 9 zilizopita ShahidMahmud 3 |