首页| JavaScript| HTML/CSS| Matlab| PHP| Python| Java| C/C++/VC++| C#| ASP| 其他|
购买积分 购买会员 激活码充值

您现在的位置是:虫虫源码 > 其他 > MySQL数据库增量备份使用mysqldump

MySQL数据库增量备份使用mysqldump

  • 资源大小:11.04 kB
  • 上传时间:2021-06-30
  • 下载次数:0次
  • 浏览次数:0次
  • 资源积分:1积分
  • 标      签: mysql backup Incremental mysqldump

资 源 简 介

On first run this script will detect auto-incremental columns from the database tables, store it"s max(value) into a special file called point file, and on the next runs will run mysqldump with --where param auto-incremental column > last max(value). As output is small, it"s a perfect candidate to send the incremental backups to some email every some hours. It"s not a replacement for full backups or for binary logs. It cannot detect deleted or updated rows.
VIP VIP
0.265415s