innobackupex: Error: no
innobackupex: Error: no 'mysqld' group in MySQL options
MySQL 5.6.19编译安装详细步骤
Mysql 5.6.19编译安装,mysql初始化设置
InnoDB: Error: log file ./ib_logfile0 is of different size 5242880 bytes
[root@zhanglin bin]# ./xtrabackup --defaults-file=/etc/my.cnf --backup --log-stream --target-dir=/mysqlbak/xtrabackup/delta./xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )xtrabackup: uses posix_fadvise().xtrabackup: cd to /usr/local/mysql/dataxtraba...
MySQL 5.6 xtrabackup 全量和增量的备份和恢复
MySQL 5.6 xtrabackup 全量备份和恢复 xtrabackup增量备份恢复
xtrabackup: Error: cannot open /../../base/xtrabackup_checkpoints
2014.10.22 昨天在做MySQL 5.6 xtrabackup 增量备份测试的时候,遇见下面的错误,搞了大半个下午都没与解决,度娘也没有给出解决方案,问了大牛,也没给出。今天早上到公司,去到官网,把官方的文档看了一篇,还好看得懂英文的,这才解决了。[root@BIDEVEDW_DB bin]# ./...
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
Lock wait timeout exceeded; try restarting transaction
MySQL :Ignoring query to other database
2014.10.31 遇见了一个低级的报错,记下来:[root@ZHANGLIN bin]# ./mysql -root -pEnter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 87506Server version: 5.6.19 Source distributionCopyright (c) 2000, 2014, Oracle a...
/usr/share/mysql/czech/errmsg.sys from *** conflicts with file from package **
file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.6.19-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-4.el6.x86_64
Linux 6.2 安装infobright
Linux 6.2 安装infobright 和参数说明
启动infobright的时候遇见Can't find file: './mysql/host.frm'
Can't find file: './mysql/host.frm'
InfoBright4.5企业版安装详细步骤
InfoBright4.5企业版安装详细步骤
ERROR 1044 (42000): Access denied for user 'root'@'%' to database
ERROR 1044 (42000): Access denied for user 'root'@'%' to database
MySQL5.6添加root用户报错:Field 'ssl_cipher' doesn't have a default value
MySQL5.6添加root用户
cursor: pin S 等待事件
cursor: pin S
SQL优化 之 -- join
SQL优化join
control file sequential read等待事件
control file sequential read等待事件
查看造成等待事件的具体SQL语句
查看造成等待事件的具体SQL语句
安装RAC: /etc/resolv.conf failed
2015.06.09 今天在做rac实验时,在prerequis ite checks 步骤时出现这个错误检测/etc/resolv.conf失败,因为DNS不可用或者没有配置DNS,我的是不可用 可以忽略该警告,不影响安装,或配置正确的dns服务,重新检测。我是直接忽略,ok了...
Error in invoking target 'irman ioracle' of makefile
Error in invoking target 'irman ioracle' of makefile
crs_stat -t CRS-0184: Cannot communicate with the CRS daemon
CRS-0184: Cannot communicate with the CRS daemon