- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
来源:互联网 发布:养猫 知乎 编辑:程序博客网 时间:2024/06/07 20:33
[root@localhost ~]# mysqldump --all-databases --single-transaction --master-data=1 --flush-logs --result-file=dump.sql -S /tmp/mysql3306.sock
-- Warning: Skipping the data of table MySQL.event. Specify the --events option explicitly.
mysql用mysqldump导出数据库时提示“-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.”
这是因为mysqldump默认是不备份事件表的,解决办法:
1、加上--events \ -E (这样就会备份事件表)
[root@localhost ~]# mysqldump --all-databases --single-transaction --master-data=1 --flush-logs --result-file=dump.sql -E -S /tmp/mysql3306.sock
[root@localhost ~]#
2、加上--ignore-table=mysql.event (这样就显示地不会备份事件表)
[root@localhost ~]# mysqldump --all-databases --single-transaction --master-data=1 --flush-logs --result-file=dump.sql --ignore-table=mysql.event -S /tmp/mysql3306.sock
[root@localhost ~]#
--本篇文章转自:- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
- -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly
- - Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
- mysql5.5全备份的问题(- Warning: Skipping the data of table mysql.event. Specify the --events option expli)
- mysql 5.5 Warning: Skipping the data of table mysql.event&&mysqldump: Got error: 1142
- Abut the warning "Warning: skipping non-radio button in group
- modify the data of system table
- android打包提示specify the option dontskipnonpubliclibraryclassmembers
- The method to fix "Please specify the assembly explicitly in the type name."
- 86.Examine the structure and data of the CUST_TRANS table:
- DataTables warning (table id = 'data-table-1'): Requested unknown parameter '9' from the data source
- The notes of Algorithms ---- Data Structures ---- Hash Table
- Example of the SO_REUSEADDR Option
- 82.Examine the data in the CUST_NAME column of the CUSTOMERS table.
- 83.Examine the data in the CUST_NAME column of the CUSTOMERS table.
- 101.Examine the data in the PROMO_BEGIN_DATE column of the PROMOTIONS table:
- 106.Examine the data in the LIST_PRICE and MIN_PRICE columns of the PRODUCTS table:
- 解决QT中文5.6 QTextEdit QPlainTextEdit的右键菜单翻译不全
- Webview加载本地图片的方案对比
- 零假设和备择假设
- Android仿英雄联盟/斗鱼波形加载动画
- sakura
- - Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
- 第12章:Continuous Latent Variables exercise 13-23
- 二维数组中的查找
- 参加高通培训
- 给你的头像+1 的opencv实现
- JavaScript 的性能优化:加载和执行
- Android 支付宝以及微信支付快速接入流程
- B进制星球
- BZOJ1061: [Noi2008]志愿者招募