数据库
owen42087743
这个作者很懒,什么都没留下…
展开
-
从windows迁移mysql到linux
1. centos,安装mysql[code="java"]# yum install mysql mysql-serverwget http://mirrors.163.com/centos/5/os/i386/CentOS/mysql-server-5.0.77-4.el5_6.6.i386.rpmrpm -ivh mysql-server-5.0.77-4.el5_6...原创 2011-09-18 16:29:11 · 161 阅读 · 0 评论 -
mysql录入数据限制
默认情况下,mysql在录入数据时会有大小限制,所以在通过sql录入大量数据时需要将限制打开:[code="java"]vi /etc/my.cnfmax_allowed_packet=100000000[/code]原创 2011-12-27 19:33:11 · 399 阅读 · 0 评论 -
搭建mongodb副本集
1. 下载mongodb[code="java"]wget http://fastdl.mongodb.org/linux/mongodb-linux-x86_64-1.8.4.tgz[/code]2. 安装mongodb(node1)[code="java"]tar -zxvf mongodb-linux-x86_64-1.8.4.tgzmv mongodb-li...原创 2011-12-04 23:49:05 · 114 阅读 · 0 评论 -
mysql连接限制
1. c3p0在运行一段时间后总是抛出错误:“Thread unexpectedly interrupted while performing an acquisition attempt”,查看log,发现“Data source rejected establishment of connection, message from server: "Too many connectio...原创 2012-02-08 15:51:51 · 657 阅读 · 0 评论 -
mongoimport和mongoexport
1. mongoexport[code="java"]/opt/mongodb/node1/mongodb-linux-x86_64-1.8.4/bin/mongoexport -h ${host}:${port} -d ${database} -c ${collection} -o ~/xxxx.json[/code]2. mongoimport[code="java"]...原创 2012-03-30 15:01:28 · 137 阅读 · 0 评论