摘要：
[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
阅读(259)
推荐(0)
编辑
摘要：
yum -y install perl-DBD-mysql
阅读全文
posted @ 2014-08-11 17:27
zitong
阅读(1997)
推荐(0)
编辑
摘要：
update 表名 set 某列名=now() where user in('user1','user2','user3');
阅读全文
posted @ 2014-08-11 17:10
zitong
阅读(372)
推荐(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
阅读(738)
推荐(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
阅读(896)
推荐(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
阅读(742)
推荐(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
阅读(964)
推荐(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
阅读(401)
推荐(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
阅读(705)
推荐(0)
编辑
2014年8月12日
