linux 文件夹sync工具

2011年07月16日 – 12:41 下午

http://sourceforge.net/projects/freefilesync/

很好用  ，很强大，只能同步本地文件夹，不能同步网络之间的文件夹

By admin | Posted in 未分类 | Comments (0)

msg sql

2011年07月15日 – 7:08 下午

– phpMyAdmin SQL Dump — version 3.2.0 — http://www.phpmyadmin.net — – Host: localhost — Generation Time: Jul 15, 2011 at 12:42 PM — Server version: 5.1.41 — PHP Version: 5.3.2-1ubuntu4.9 SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; — – Database: `msg` — — ——————————————————– — – Table structure for table `ctt0` — CREATE TABLE IF NOT EXISTS `ctt0` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` varchar(250) NOT NULL, `rfid` int(11) NOT NULL, `pin` varchar(20) NOT NULL, PRIMARY KEY (`rfid`), KEY `id` (`id`), KEY `rfid` (`rfid`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `ctt0` — — ——————————————————– — – Table structure for table `ctt1` — CREATE TABLE IF NOT EXISTS `ctt1` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` varchar(250) NOT NULL, `rfid` int(11) NOT NULL, `pin` varchar(20) NOT NULL, PRIMARY KEY (`rfid`), KEY `id` (`id`), KEY `rfid` (`rfid`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `ctt1` — — ——————————————————– — – Table structure for table `ctt2` — CREATE TABLE IF NOT EXISTS `ctt2` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` varchar(250) NOT NULL, `rfid` int(11) NOT NULL, `pin` varchar(20) NOT NULL, PRIMARY KEY (`rfid`), KEY `id` (`id`), KEY `rfid` (`rfid`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `ctt2` — — ——————————————————– — – Table structure for table `ctt3` — CREATE TABLE IF NOT EXISTS `ctt3` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` varchar(250) NOT NULL, `rfid` int(11) NOT NULL, `pin` varchar(20) NOT NULL, PRIMARY KEY (`rfid`), KEY `id` (`id`), KEY `rfid` (`rfid`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `ctt3` — — ——————————————————– — – Table structure for table `ctt4` — CREATE TABLE IF NOT EXISTS `ctt4` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` varchar(250) NOT NULL, `rfid` int(11) NOT NULL, `pin` varchar(20) NOT NULL, PRIMARY KEY (`rfid`), KEY `id` (`id`), KEY `rfid` (`rfid`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `ctt4` — — ——————————————————– — – Table structure for table `ctt5` — CREATE TABLE IF NOT EXISTS `ctt5` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` varchar(250) NOT NULL, `rfid` int(11) NOT NULL, `pin` varchar(20) NOT NULL, PRIMARY KEY (`rfid`), KEY `id` (`id`), KEY `rfid` (`rfid`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `ctt5` — — ——————————————————– — – Table structure for table `ctt6` — CREATE TABLE IF NOT EXISTS `ctt6` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` varchar(250) NOT NULL, `rfid` int(11) NOT NULL, `pin` varchar(20) NOT NULL, PRIMARY KEY (`rfid`), KEY `id` (`id`), KEY `rfid` (`rfid`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `ctt6` — — ——————————————————– — – Table structure for table `ctt7` — CREATE TABLE IF NOT EXISTS `ctt7` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` varchar(250) NOT NULL, `rfid` int(11) NOT NULL, `pin` varchar(20) NOT NULL, PRIMARY KEY (`rfid`), KEY `id` (`id`), KEY `rfid` (`rfid`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `ctt7` — — ——————————————————– — – Table structure for table `ctt8` — CREATE TABLE IF NOT EXISTS `ctt8` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` varchar(250) NOT NULL, `rfid` int(11) NOT NULL, `pin` varchar(20) NOT NULL, PRIMARY KEY (`rfid`), KEY `id` (`id`), KEY `rfid` (`rfid`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `ctt8` — — ——————————————————– — – Table structure for table `ctt9` — CREATE TABLE IF NOT EXISTS `ctt9` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` varchar(250) NOT NULL, `rfid` int(11) NOT NULL, `pin` varchar(20) NOT NULL, PRIMARY KEY (`rfid`), KEY `id` (`id`), KEY `rfid` (`rfid`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `ctt9` — — ——————————————————– — – Table structure for table `msg0` — CREATE TABLE IF NOT EXISTS `msg0` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(250) NOT NULL, `pin` varchar(20) NOT NULL, `operator` varchar(10) NOT NULL, `createtime` datetime NOT NULL, `state` tinyint(1) NOT NULL, `msgtype` tinyint(1) NOT NULL, `uuid` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `pin` (`pin`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `msg0` — — ——————————————————– — – Table structure for table `msg1` — CREATE TABLE IF NOT EXISTS `msg1` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(250) NOT NULL, `pin` varchar(20) NOT NULL, `operator` varchar(10) NOT NULL, `createtime` datetime NOT NULL, `state` tinyint(1) NOT NULL, `msgtype` tinyint(1) NOT NULL, `uuid` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `pin` (`pin`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `msg1` — — ——————————————————– — – Table structure for table `msg2` — CREATE TABLE IF NOT EXISTS `msg2` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(250) NOT NULL, `pin` varchar(20) NOT NULL, `operator` varchar(10) NOT NULL, `createtime` datetime NOT NULL, `state` tinyint(1) NOT NULL, `msgtype` tinyint(1) NOT NULL, `uuid` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `pin` (`pin`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `msg2` — — ——————————————————– — – Table structure for table `msg3` — CREATE TABLE IF NOT EXISTS `msg3` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(250) NOT NULL, `pin` varchar(20) NOT NULL, `operator` varchar(10) NOT NULL, `createtime` datetime NOT NULL, `state` tinyint(1) NOT NULL, `msgtype` tinyint(1) NOT NULL, `uuid` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `pin` (`pin`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `msg3` — — ——————————————————– — – Table structure for table `msg4` — CREATE TABLE IF NOT EXISTS `msg4` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(250) NOT NULL, `pin` varchar(20) NOT NULL, `operator` varchar(10) NOT NULL, `createtime` datetime NOT NULL, `state` tinyint(1) NOT NULL, `msgtype` tinyint(1) NOT NULL, `uuid` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `pin` (`pin`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `msg4` — — ——————————————————– — – Table structure for table `msg5` — CREATE TABLE IF NOT EXISTS `msg5` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(250) NOT NULL, `pin` varchar(20) NOT NULL, `operator` varchar(10) NOT NULL, `createtime` datetime NOT NULL, `state` tinyint(1) NOT NULL, `msgtype` tinyint(1) NOT NULL, `uuid` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `pin` (`pin`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `msg5` — — ——————————————————– — – Table structure for table `msg6` — CREATE TABLE IF NOT EXISTS `msg6` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(250) NOT NULL, `pin` varchar(20) NOT NULL, `operator` varchar(10) NOT NULL, `createtime` datetime NOT NULL, `state` tinyint(1) NOT NULL, `msgtype` tinyint(1) NOT NULL, `uuid` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `pin` (`pin`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `msg6` — — ——————————————————– — – Table structure for table `msg7` — CREATE TABLE IF NOT EXISTS `msg7` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(250) NOT NULL, `pin` varchar(20) NOT NULL, `operator` varchar(10) NOT NULL, `createtime` datetime NOT NULL, `state` tinyint(1) NOT NULL, `msgtype` tinyint(1) NOT NULL, `uuid` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `pin` (`pin`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `msg7` — — ——————————————————– — – Table structure for table `msg8` — CREATE TABLE IF NOT EXISTS `msg8` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(250) NOT NULL, `pin` varchar(20) NOT NULL, `operator` varchar(10) NOT NULL, `createtime` datetime NOT NULL, `state` tinyint(1) NOT NULL, `msgtype` tinyint(1) NOT NULL, `uuid` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `pin` (`pin`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `msg8` — — ——————————————————– — – Table structure for table `msg9` — CREATE TABLE IF NOT EXISTS `msg9` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(250) NOT NULL, `pin` varchar(20) NOT NULL, `operator` varchar(10) NOT NULL, `createtime` datetime NOT NULL, `state` tinyint(1) NOT NULL, `msgtype` tinyint(1) NOT NULL, `uuid` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `pin` (`pin`) ) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=1 ; — – Dumping data for table `msg9` –

By admin | Posted in 未分类 | Comments (0)

jquery

2011年07月14日 – 11:46 下午
By admin | Posted in 未分类 | Comments (1)

分库分表算法

2011年07月12日 – 6:36 下午

//分库分表算法
function calc_hash_db($u, $s = 4)
{
$h = sprintf(“%u”, crc32($u));
$h1 = intval(fmod($h, $s));
return $h1;
}

for($i=1;$i<100;$i++)
{
echo calc_hash_db($i);
echo “<br>”;
}

function calc_hash_tbl($u, $n = 256, $m = 16)
{
$h = sprintf(“%u”, crc32($u));
$h1 = intval($h / $n);
$h2 = $h1 % $n;
$h3 = base_convert($h2, 10, $m);
$h4 = sprintf(“%02s”, $h3);
return $h4;
}

By admin | Posted in 未分类 | Comments (0)

linux挂载新分区到指定目录并生效

2011年07月11日 – 4:22 下午

已知：将 /dev/sda1 这个分区挂到 /home（或类似）目录后，该文件夹下原来的文件都要作废，所以要复制过去，具体操作如下（以将 /dev/sda4这个ext4 分区 挂载为 /var目录下为例

此次操作有些地方删除有些暴力，主要是为了不重启系统

1.将/devsda4 这个分区格式化为ext4 分区（最简单的办法是用gparted，图形化界面便于操作）

2.mkdir  /varnew （先建个目录）

3.  mount  /dev/sda4  /varnew  （将此分区挂个目录，准备copy文件）

4.  cp -pr  /var/×   /varnew  （将现在var目录下所有文件以保留文件时间和权限的方式copy到新的要挂载的这个分区）

5.  rm -rf  /var  删掉 var目录

6. vi /etc/fstab

添加以下信息   /dev/sda4   /var   ext4   defaults  0  1

6.mount -a  （会读取/etc/fstab这个文件并按照刚刚这个挂载，就不用重启系统了）

到此这个目录就挂到新的分区了

需要注意的是如果是挂到某些特殊的系统目录可能影响系统运行，最好还是重启进入livecd挂载

By admin | Posted in 未分类 | Comments (0)

chrome下一个好用的cookie编辑器

2011年06月24日 – 11:12 上午

https://chrome.google.com/webstore/detail/fngmhnnpilhplaeedifhccceomclgfbg

这个是地址

挺好用的

chrome

By admin | Posted in 未分类 | Comments (0)

mysql常用命令

2011年06月23日 – 11:54 下午

where id like ‘jack%’；  # %表示任何字符任意次数where id like ‘jack%’；  # %表示任何字符任意次数where id like ‘jack%’；  # %表示任何字符任意次数tablename 指某个表名

show databases;   显示数据库

show tables; 显示表

show columns from tablename /desc tablename; 显示表结构

show grants  显示用户的安全权限

show errors  /show warnings  显示服务器错误或警告信息

##############检索数据###########

select column from tablename; 检索某列

select * from tablename;  检索所有字段

select columna,columnb from tablename; 检索指定字段

select distinct name from tablename;  检索出不重复的值(比如共有3行,a  b  a,则结果显示 a b

select * from tablename limit 5; 最多5行

select * from tablename limit 10,5;从第10行开始返回5行

select tablename.columnname from database.tablename 使用完全限定的表名

select columna from tablename order by columnb    查询a列,结果按b列排序 (默认,升序)

select columna from tablename order by columnb  desc   查询a列,结果按b列排序(指定,降序)

select columna from tablename order by columna,columnb      查询a列,结果按a先排序,再按b列排序

select columna from tablename order by columna desc,columnb      查询a列,结果按a先(降序)排序,再按b列排序

select columna from tablename order by columna desc,columnb limt 1 使用 limit 1 就可以找到最大或者最小值

select columna from tablename order by columna where columna=111 order by  columna;从表中检索a列等于111的情况,以a列升序排列

select columna from tablename order where columna=100  <=100

where columna <>abc                      不等于

where  height between 100 and 200 范围

where name is null  检查空值

where name =1 and id=2  组合条件

where name =1 or id=2  组合条件

select id and price from table where id <1000 or id>2000 and price>10     = select id and price from table where (id<1000) or (id>2000 and price >10)

select id and price from table where (id<1000 or id>2000) and price >10  检索小于1000或大于2000的价格大于10的

where id in (1000,1001)    # in操作符  功能与or相当

where id not in (1000,1001)  #not 操作符

##通配符##

where id like ‘jack%’；  # %表示任何字符任意次数

where id like ‘jack_’；  # _表示任何单个字符

##正则##

where id regexp ’1000′;  #类似like

where id regexp ’1000｜2000｜3000′;  #类似like

where id regexp ‘[123]reg’;  #返回 1reg  2reg  3reg

where id regexp ‘\\.’  #查找 含有 .的 id值

where id  regexp  ’[[:digit:]]{4}’  # 等于 ‘[0-9][0-9][0-9][0-9]‘

where id regexp  ’^[0-9\\.]‘  #匹配以 0－9或者.开头的值

##end of Page 80##

concat (c1,c2) from table  #拼接字段

concat  (c1,c2) as cn from table #别名

select upper(name) from table #类似的有left right  lower  ltrim  rtrim 等

abs(id)   #abs

select avg(id) from table  #汇总数据  ,还有  count()  max() min()  sum()

select avg(distinct  id) from table #distinct 不同的

select count(*) from table  #count

select  id ,count(*) as num_id from table

select id,count( *) from  table  group by id having  count (*) >=2;

select  id ,count (*) from table where  id >1000 group by  id having count (*)>=2;

# select  from  where  group  by  having  order by  limit

#子查询

select  id from table  where num in (select  num from tableb where pid =’xxx’ );

select  noteclum  where match(noteclum) against(‘xxxx’)  全文搜索

#插入数据

insert into user values (null,’aaa’,'bbb’);

insert into user values (null,’aaa’,'bbb’),(null,’xxx’,'zzz’);

insert into ctt1 select * from ctt0;  #将查询出的数据插入到表中
#更新数据
update table set clua=’xxx’ where id=’11′;
update table set clua=’xxx’ ,club=’zzz’  where id=’11′;
#删除数据
delete from table where id=xx
#创建表
create table tablename(uid int not null,
name varchar(20) not null,
nameb varchar(20) not null,
PRIMARY KEY(uid))ENGINE=InnoDB;
PRIMARY KEY(uid,name))ENGINE=InnoDB;  #由多列组成的主键
#同一数据库的表引擎可以不同，但是外键不能跨引擎
#增加列
alter tablename add clux char(20);
#删除列
alter tablename drop column uid;
P165



By admin | Posted in 未分类 | Comments (0)

chrome扩展添加host访问

2011年06月20日 – 8:14 下午

狗日的GFW给封了，要绑定host才能访问

74.125.39.99 chrome.google.com

74.125.39.99 clients2.google.com

By admin | Posted in 未分类 | Comments (0)

双linux直接格掉一个主系统的grub修复记录

2011年05月30日 – 4:22 下午

参考了这个http://zhidao.baidu.com/question/209639907.html

在启动失败进入 grub rescue后输入

ls ，可以看到分区如 hd(0,1) hd(0,5)等

然后 ls hd(0,5)/   （注意后面的/）可以看到分区的内容，便于判断是哪个分区

然后找到 /所在的分区之后

按照如下格式输入

grub rescue>root=(hd0,x)
grub rescue>prefix=/boot/grub
grub rescue>set root=(hd0,x)
grub rescue>set prefix=(hd0,x)/boot/grub
grub rescue>insmod normal
rescue>normal
另外一个非常有用的东西就是修复了，上面的命令只能有效一次，重启后还要重新输入一次
按照刚刚的输入完进入系统以后，
进入shel分别使用以下命令


重建配置文件grub.cfg
sudo update-grub
重建grub到第一硬盘mbr
sudo grub-install /dev/sda




就可以修复好grub，再次启动就可以直接出现grub的正常启动菜单了




								

				

					By admin
					|
					Posted in 未分类
					|
										Comments (0)
				

			




			

				
php模拟浏览器进行带cookie的post数据

				
2011年05月28日 – 12:02 上午

				




<?php


/*


* To change this template, choose Tools | Templates


* and open the template in the editor.


*/


$post_data = array();


$post_data['user'] = “zs”;


$post_data['passwd'] = “zspwd”;


$post_data['submit'] = “submit”;


$url=’http://localhost/test/index.php’;


$cookie = “a=b;c=d”;


$o=”";


foreach ($post_data as $k=>$v)


{


$o.= “$k=”.urlencode($v).”&”;


}


$post_data=substr($o,0,-1);


$ch = curl_init();


curl_setopt($ch, CURLOPT_POST, 1);


curl_setopt($ch, CURLOPT_HEADER, 0);


curl_setopt($ch, CURLOPT_URL,$url);


curl_setopt ($ch, CURLOPT_COOKIE , $cookie );


//为了支持cookie


curl_setopt($ch, CURLOPT_COOKIEJAR, ‘cookie.txt’);


curl_setopt($ch, CURLOPT_POSTFIELDS, $post_data);


$result = curl_exec($ch);


echo $result;


?>


								

				

					By admin
					|
					Posted in 未分类
					|
										Comments (0)