mysqldump --flush-logs

最新推荐文章于 2022-12-30 11:59:57 发布

scan724

最新推荐文章于 2022-12-30 11:59:57 发布

阅读量1.8k

点赞数

本文链接：https://blog.csdn.net/zhaoyangjian724/article/details/46446649

版权

<pre name="code" class="ruby">  -F, --flush-logs    Flush logs file in server before starting dump. Note that
                      if you dump many databases at once (using the option
                      --databases= or --all-databases), the logs will be
                      flushed for each database dumped. The exception is when
                      using --lock-all-tables or --master-data: in this case
                      the logs will be flushed only once, corresponding to the
                      moment all tables are locked. So if you want your dump
                      and the log flush to happen at the same exact moment you
                      should use --lock-all-tables or --master-data with
                      --flush-logs.


刷新日志(binlog): Flush logs file在开始dump前,注意  如果你dump一次多个数据库 (使用选项 --databases= or --

all-databases)


 日志会被刷新 对于每个数据库被dump  .  例外是当使用  --lock-all-tables or --master-data: 


在这章情况下 日志只会被刷新一次, 所有的表都会被锁住。