数据库
owen42087743
这个作者很懒,什么都没留下…
展开
-
从windows迁移mysql到linux
1. centos,安装mysql [code="java"] # yum install mysql mysql-server wget http://mirrors.163.com/centos/5/os/i386/CentOS/mysql-server-5.0.77-4.el5_6.6.i386.rpm rpm -ivh mysql-server-5.0.77-4.el5_6...原创 2011-09-18 16:29:11 · 150 阅读 · 0 评论 -
mysql录入数据限制
默认情况下,mysql在录入数据时会有大小限制,所以在通过sql录入大量数据时需要将限制打开: [code="java"] vi /etc/my.cnf max_allowed_packet=100000000 [/code]原创 2011-12-27 19:33:11 · 381 阅读 · 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.tgz mv mongodb-li...原创 2011-12-04 23:49:05 · 104 阅读 · 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 · 625 阅读 · 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 · 112 阅读 · 0 评论