write down,forget
标签 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

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