mysql5.5全备份的问题(- Warning: Skipping the data of table mysql.event. Specify the --events option expli)
来源:互联网 发布:深蓝知乎 编辑:程序博客网 时间:2024/06/05 16:55
备份的报错的问题
[root@localhost ]# mysqldump -uroot --all-databases > /usr/nfyg/all.sql
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
查看数据库版本
[root@localhost ]# mysql -V
mysql Ver 14.14 Distrib 5.5.31, for Linux (x86_64) using readline 5.1
解决方法
[root@localhost nfyg]# mysqldump -uroot --events --all-databases > /usr/nfyg/all.sql
0 0
- mysql5.5全备份的问题(- Warning: Skipping the data of table mysql.event. Specify the --events option expli)
- -- 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.
- 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
- 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
- MySQL解决[Err] 1206 - The total number of locks exceeds the lock table size问题
- Warning:The /usr/local/mysql/data directory is not owned by the 'mysql' or '_mysql'的解决办法
- 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:
- 72. Edit Distance
- 226. Invert Binary Tree
- 你不知道的Java学习笔记15--StringBuffer类
- Lucene学习教程——Lucene索引创建
- android中ArrayList源码分析
- mysql5.5全备份的问题(- Warning: Skipping the data of table mysql.event. Specify the --events option expli)
- CODEVS 2072 分配房间
- spark如何划分stage
- centos下安装git
- Android属性动画(二)——ValueAnimator
- Git安装与基本操作总结
- Jquery datatable 页面报错 Ajax error
- Java基础学习总结(64)——Java内存管理
- 对分查找(Binary Search)