[root@dns var]# service mysqld stop Shutting down MySQL.. [root@dns bin]# ./mysql_install_db --user=mysql --datadir=/data/mysql_data2
拷贝文件一次读写五十个字符。第一个参数是源文件名,第二个参数是新文件名。def copyFile(oldFile,newFile): f1=open(oldFile,"r") f2=open(newFile,"w") while 1: text=f1.read(50) if text=="": break
>>> import sys >>> sys.path.append('E:/cncgcg') >>> import hello2
修改my.cnf文件中的bin-log路径后,mysql无法启动经查询,原来是/data/mysql_data/目录权限不对修改前:修改后:然后就可以正常启动
[root@dns soft]# cat auto_install_mysql.sh #!/bin/sh set -x groupadd mysql useradd -g mysql mysql #mkdir /usr/local/mysql mysql_dir1=/data/soft/mysql-5.1.5
[root@dns shell]# cat network.sh #!/bin/bash ETH=$1 ETH=${ETH:-eth1} IP=`ifconfig $ETH|awk -F '[ :]+' '/inet addr/{print $4}'` while true;do let I+=1 NOW=`date
#!/bin/bash if [[ -f /usr/bin/lsb_release ]]; then OS=$(/usr/bin/lsb_release -a |grep Description |awk -F : '{print $2}' |sed 's/^[ \t]*//g') else OS=$(cat /etc/issue |sed -n '1p') fi OS_version
[root@VM_163_107 /data/script/shell]# vim moni_pid.sh #!/bin/sh #set -x pid1=`ps -ef|grep QD|grep -v grep |awk '{print $14}'|grep QWorld` pid2=`ps -ef|grep QD|grep -v grep |awk '{print $14}'|grep
第一版#!/bin/sh set -x groupadd nagios useradd -g nagios -s /sbin/nologin nagios cd nrpe-2.12 ./configure make all make install-plugin make install-daemon make in
centos6.2wget http://mirrors.163.com/.help/CentOS6-Base-163.repo -O /etc/yum.repos.d/CentOS-Base.repo 然后使用yum clean all yum makecache 最后才用yum install openssl-devel若是centos5则用下面链接网易源 http://mirro
修改/opt/apache-tomcat-7.0.29//bin/startup.sh 为:export JAVA_HOME=/opt/jdk1.7.0_25 export CLASSPATH=$CLASSPATH:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar:. export PATH=$PATH:$JAVA_HOME/bin export
[root@linux-212 ~]# cat /etc/sysconfig/network-scripts/ifcfg-em1 DEVICE=em1 HWADDR=84:2B:2B:59:92:59 BOOTPROTO=static BROADCAST=192.168.1.212 IPADDR=192.168.1.212 NETMASK=255.255.255.0 NETWORK=
安装readline-6.2.4.1时报:“ImportError: No module named setuptools”错误。则要安装setuptools 0.9.6即可继续报错gcc: readline/libreadline.a: No such file or directorygcc: readline/libhistory.a: No such file or directoryer
1、测试端口@echo off title 测试端口 echo. :loop ;netstat -an |findstr 3389 ping 127.1 -n 5 > nul echo. echo. echo. echo 每五秒钟测试一次 goto :loop2、测试进程@echo off title 测试进程 echo. :run tasklist
#!/bin/sh set -x export data=`date +%Y%m%d%H%M` export prosum=`ps -ef|grep QD|wc -l` export data2=`date +%H` echo $prosum echo $data2 if [ $data2 -gt 2 -a $data2 -lt 6 ] then
windows安装python-mysqldb模块下载http://www.codegood.com/archives/4直接双击后安装即可MySQL-python-1.2.2.win-amd64-py2.6.exe下载libguide40.dll、libmmd.dll后,放在System32目录中在python中使用MySQLpython 2.7直接下载安装即可http://www.codego
gamedb:/data/script/python # cat 1.py #!/usr/bin/python file_object = open('txt/b.txt') all_the_txt = file_object.read() all_the_txt = all_the_txt.replace('b','D') file_object2 = open(r'/data/scr
#!/bin/sh cd /opt/xyrpg/rpgserver/webserver/ nohup ./webServer &nohup 你的shell命令 &这样就可以将命令丢到后台运行nohup命令可以让你的shell命令忽略SIGHUP信号,即可以使之脱离终端运行;“&”可以让你的命令在后台运行。
show processlist;
游戏创建角色时无法创建中文名,但是创建纯数字的可以创建,查看数据库的字符集。mysql> show variables like 'character\_set\_%'; +--------------------------+--------+ | Variable_name | Value | +--------------------------+----
[root@mail conf]# cat haproxy.cfg global chroot /usr/local/haproxy # more secure daemon nbproc 1 group nobody user nobody log 127.0.0.1 local0 info # syslog pidfile /usr/local/ha
mysql> select from_unixtime(CreateTime) from xy_tbl_roleinfo;
:%s/DEFINER=\`root\`@\`%\`/ /g将全文中的DEFINER=`root`@`%`替换成空格淘宝小店-运维学习参考资料http://shop62632578.taobao.com
groupadd user250 for (( i=1;$i<=1000;i++ )) do useradd $user$i -G user250 echo user$i >> /home/1.txt done
[root@mail scripts]# cat information.sh #!/bin/bash #登录服务器时,显示相关信息。 echo -e "\033[31m "CPU核数:" `cat /proc/cpuinfo |grep processor | wc -l`"核" `vmstat |grep [0-9]|awk '{print" 用户时间: " $13 \ "%"
linux:SQL 来备份 MyISAM 表: /usr/local/mysql/bin/mysqldump -uroot -p123 --default-character-set=utf8 --opt --extended-insert=false --triggers -R --hex-blob -x db_name > db_name.sql 使用以下 SQL 来备份 Innodb
mysqldump--导出工具#导出某个数据库--结构+数据shell>mysqldump -h192.168.161.124 -uroot -pxxxxxx --opt db_name |gzip -9 > /db_bakup/db_name.gz#导出某个数据库的表--结构+数据+函数+存储过程shell>mysqldump -h192.168.161.124 -uroot
查询数据库教程中的存储过程:示例一:(直接查询某一个库中的存储过程)mysql> select `name` from mysql.proc where db = 'xy_db_gm' and `type` = 'PROCEDURE'; +-------------------------------------------------+ | name
在rpm包安装完1.7的版本后还是显示1.6的版本问题查询gamedb:/usr/java/jdk1.7.0_25/bin # java -version java version "1.6.0_23" Java(TM) SE Runtime Environment (build 1.6.0_23-b05) Java HotSpot(TM) Server VM (build 19.0-b09
查看后台在运行的进程[root@VM_163_107 /data/soft/testhttp]# ./testhttp & [1] 30696 [root@VM_163_107 /data/soft/testhttp]# starting ............. data len 2 119.131.20.199 - - [10/Jul/2013 15:11:56] "GET
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号