2014年8月11日
摘要: [root@test]# /usr/local/mysql/bin/mysql -urootERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)[root@test]#... 阅读全文
posted @ 2014-08-11 17:35 zitong 阅读(239) 评论(0) 推荐(0) 编辑
摘要: yum -y install perl-DBD-mysql 阅读全文
posted @ 2014-08-11 17:27 zitong 阅读(1985) 评论(0) 推荐(0) 编辑
摘要: update 表名 set 某列名=now() where user in('user1','user2','user3'); 阅读全文
posted @ 2014-08-11 17:10 zitong 阅读(364) 评论(0) 推荐(0) 编辑
摘要: [root@test]# perl -MCPAN -e 'install DBD::mysql'Can't locate CPAN.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl... 阅读全文
posted @ 2014-08-11 15:18 zitong 阅读(730) 评论(0) 推荐(0) 编辑
摘要: [root@ma src]# innobackupex --user=root /root/backup --no-timestampInnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percon... 阅读全文
posted @ 2014-08-11 15:16 zitong 阅读(894) 评论(0) 推荐(0) 编辑
摘要: Can't locate Time/HiRes.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/vendor_perl... 阅读全文
posted @ 2014-08-11 15:15 zitong 阅读(736) 评论(0) 推荐(0) 编辑
摘要: 书上摘抄 ---深入浅出mysql 448页grant reload on *.* to 'backup'@'localhost' identified by '123456';grant reload,lock tables on *.* to 'backup'@'localhost' ident... 阅读全文
posted @ 2014-08-11 14:30 zitong 阅读(956) 评论(0) 推荐(0) 编辑
摘要: 安装percona-xtrabackup-2.1.5过程中遇到如下问题:[root@test percona-xtrabackup-2.1.5]# ./utils/build.sh innodb56Downloading sourcesPreparing sources./utils/build.s... 阅读全文
posted @ 2014-08-11 13:55 zitong 阅读(394) 评论(0) 推荐(0) 编辑
摘要: gzip: stdin: unexpected end of filetar: Unexpected EOF in architar: Unexpected EOF in archivevetar: Error is not recoverable: exiting now从网上下载了一个tar的文... 阅读全文
posted @ 2014-08-11 10:38 zitong 阅读(700) 评论(0) 推荐(0) 编辑
摘要: 1.下载,解压并安装zabbixtar zxvf zabbix-2.0.12.tar.gzcd zabbix-2.0.12./configure --prefix=/usr/local/zabbix --enable-agentmake&&make install2.配置zabbix_agentd... 阅读全文
posted @ 2014-08-11 10:35 zitong 阅读(313) 评论(0) 推荐(0) 编辑