write down,forget
adidas eqt support ultra primeknit vintage white coming soon adidas eqt support ultra boost primeknit adidas eqt support ultra pk vintage white available now adidas eqt support ultra primeknit vintage white sz adidas eqt support ultra boost primeknit adidas eqt adv support primeknit adidas eqt support ultra boost turbo red white adidas eqt support ultra boost turbo red white adidas eqt support ultra boost turbo red adidas eqt support ultra whiteturbo adidas eqt support ultra boost off white more images adidas eqt support ultra boost white tactile green adidas eqt support ultra boost beige adidas eqt support ultra boost beige adidas eqt support refined camo drop adidas eqt support refined camo drop adidas eqt support refined running whitecamo adidas eqt support 93 primeknit og colorway ba7506 adidas eqt running support 93 adidas eqt support 93
标签 Tag : mysql

Got a packet bigger than ‘max_allowed_packet

<Category: mysql> Comments Off on Got a packet bigger than ‘max_allowed_packet

本文来自: Got a packet bigger than ‘max_allowed_packet

mysql开启远程访问权限错误

<Category: mysql> Comments Off on mysql开启远程访问权限错误

mysql需要开放远程访问端口,结果。。
mysql> update user set host =’%’ where user =’root’;
ERROR 1062 (23000): Duplicate entry ‘%-root’ for key ‘PRIMARY’

root用户好几个,有几个没有密码
mysql> update user set password = PASSWORD(‘xxx’) where user=’root’
-> ;
删除最后一个root用户:
localhost root

然后确保有一个%就可以了。

本文来自: mysql开启远程访问权限错误

WP后台登陆失败

<Category: Uncategorized> Comments Off on WP后台登陆失败

WP后台登陆不进去,原来表有点小问题。。。

本文来自: WP后台登陆失败

mysql-bin.000001-x

<Category: Linux, mysql> Comments Off on mysql-bin.000001-x

发达了,mysql-bin占了我9g空间啊,大汗一把:
20K mysql-bin.000001
700K mysql-bin.000002
4.0K mysql-bin.000003
4.0K mysql-bin.000004
4.0K mysql-bin.000005
4.0K mysql-bin.000006
4.0K mysql-bin.000007
4.0K mysql-bin.000008
4.0K mysql-bin.000009
4.0K mysql-bin.000010
11M mysql-bin.000011
63M mysql-bin.000012
368K mysql-bin.000013
256K mysql-bin.000014
9.5M mysql-bin.000015
1.8M mysql-bin.000016
11M mysql-bin.000017
508K mysql-bin.000018
45M mysql-bin.000019
146M mysql-bin.000020
86M mysql-bin.000021
2.2M mysql-bin.000022
2.6M mysql-bin.000023
124K mysql-bin.000024
8.7M mysql-bin.000025
4.9M mysql-bin.000026
428K mysql-bin.000027
372K mysql-bin.000028
123M mysql-bin.000029
17M mysql-bin.000030
4.0K mysql-bin.000031
700K mysql-bin.000032
454M mysql-bin.000033
14M mysql-bin.000034
841M mysql-bin.000035
388M mysql-bin.000036
26M mysql-bin.000037
728K mysql-bin.000038
216M mysql-bin.000039
228M mysql-bin.000040
294M mysql-bin.000041
14M mysql-bin.000042
155M mysql-bin.000043
13M mysql-bin.000044
884K mysql-bin.000045
13M mysql-bin.000046
434M mysql-bin.000047
206M mysql-bin.000048
171M mysql-bin.000049
528K mysql-bin.000050
61M mysql-bin.000051
330M mysql-bin.000052
199M mysql-bin.000053
64M mysql-bin.000054
436K mysql-bin.000055
17M mysql-bin.000056
340K mysql-bin.000057
116M mysql-bin.000058
18M mysql-bin.000059
23M mysql-bin.000060
188M mysql-bin.000061
40K mysql-bin.000062
277M mysql-bin.000063
4.0K mysql-bin.000064
35M mysql-bin.000065
258M mysql-bin.000066
147M mysql-bin.000067
79M mysql-bin.000068
4.0K mysql-bin.000069
4.0K mysql-bin.000070
434M mysql-bin.000071
4.0K mysql-bin.000072
99M mysql-bin.000073
52M mysql-bin.000074
620K mysql-bin.000075
428M mysql-bin.000076
788K mysql-bin.000077
4.0K mysql-bin.000078
4.0K mysql-bin.000079
126M mysql-bin.000080
137M mysql-bin.000081
428K mysql-bin.000082
31M mysql-bin.000083
4.0K mysql-bin.index
阅读这篇文章的其余部分 »

本文来自: mysql-bin.000001-x

lnmp、mono与asp.net环境安装

<Category: Linux, 小道消息> Comments Off on lnmp、mono与asp.net环境安装

kloxo虽然比较强大,但是太耗资源,有些东西不一定需要,所以决定还是装LNMP。另外需要调试下ASP.NET程序,把MONO也装上了,使用fastcgi、mysql和nginx。

1.安装lnmp

asp.net支持
2.编译安装mono 2.0

3.安装完毕后可以通过“mono -V”查看mono版本

4.安装fastcgi-mono-server

 

下面的方法经测可用
#yum groupinstall Mono
But I noticed the version of Mono I installed is 1.2.4, seems that the lastversion of mono (2.4.2.3) is not in the CentOS package repositories.
Then I tried to find the last version distribution from Mono Home page and google, but no result, So I had to download the source code and compile it all by my self.
After some attempts, I got the following steps to compile and install the last version Mono on my CentOS 5.2 VPS host,
1.prepare the compile environment,
# yum install gcc bison pkgconfig glib2-devel gettext make

2.Go to this page and download the last version Mono(in my case, mono-2.4.2.3.tar.bz2),
#wget http://ftp.novell.com/pub/mono/sources/mono/mono-2.4.2.3.tar.bz2

3.Extract the downloaded file,
# tar jxvf mono-2.4.2.3.tar.bz2

4.Change to the newly created directory,
# cd mono-2.4.2.3

5.I put my built packages in /opt so, run the following command to build mono,
# ./configure –prefix=/opt/mono; make; make install
6.Update ~/.bash_profile,

#echo export PKG_CONFIG_PATH=/opt/mono/lib/pkgconfig:$PKG_CONFIG_PATH>>~/.bash_profile
#echo export PATH=/opt/mono/bin:$PATH>>~/.bash_profile
#source ~/.bash_profile

7. Test it,
#mono -V
and I got the output:

Mono JIT compiler version 2.4.2.3 (tarball Thu Oct 22 06:42:24 MSD 2009)
Copyright (C) 2002-2008 Novell, Inc and Contributors. www.mono-project.com
TLS: __thread
GC: Included Boehm (with typed GC)
SIGSEGV: altstack
Notifications: epoll
Architecture: x86
Disabled: none

Great, I got it.
I think I’d better put all script I used in one place,

mkdir ~/software
yum install gcc bison pkgconfig glib2-devel gettext make
wget http://ftp.novell.com/pub/mono/sources/mono/mono-2.4.2.3.tar.bz2
tar jxvf mono-2.4.2.3.tar.bz2
cd mono-2.4.2.3
./configure –prefix=/opt/mono; make; make install
echo export PKG_CONFIG_PATH=/opt/mono/lib/pkgconfig:$PKG_CONFIG_PATH>>~/.bash_profile
echo export PATH=/opt/mono/bin:$PATH>>~/.bash_profile
source ~/.bash_profile
mono -V
cd ..
rm -rf mono-2.4.2.3

references,
Mono Home Page
[HOWTO] Install Mono 2.4 on CentOS 5.3

nginx配置server节点之后
fastcgi-mono-server2 /socket=tcp:9000 &

重启nginx:kill -HUP cat /usr/local/nginx/logs/nginx.pid

asp.net探针截图

本文来自: lnmp、mono与asp.net环境安装

Veritas输出文件处理入库

<Category: Perl> Comments Off on Veritas输出文件处理入库

算是perl一个测验吧,完成对文本的处理,并入库mysql,写的很烂,记录一下,大家不要笑。所有文件打包

阅读这篇文章的其余部分 »

本文来自: Veritas输出文件处理入库

从数据库随机读取数据

<Category: SQL Server> Comments Off on 从数据库随机读取数据

示例代码:
SQL Server:Select Top * From  表 Order By NewID()  
Access  :Select Top * From 表 Order By Rnd(ID) 
        *说明-Rnd(ID) 其中的ID是自动编号字段,可以利用其他任何数值来完成,比如用姓名字段(UserName)  Select Top 10 * From 表 Order BY Rnd(Len(UserName))
 
MySql:Select * From 表 Order By Rand() Limit 10

本文来自: 从数据库随机读取数据