java相关命令.txt 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221
  1. 打包命令----.\gradlew.bat clean build jar
  2. mongo数据库:docker exec -it 0cbb78421194 mongo mongodb://admin:rimZBP82Ia@127.0.0.1:27017/x5_tk_login?authSource=admin
  3. nohup java -jar jenkins.war --httpPort=12567 > jenkins.log 2>&1 &
  4. tar -czvf archive.tar.gz directory/ # 压缩
  5. tar -xzvf archive.tar.gz # 解压
  6. mongo "mongodb://admin:123456@127.0.0.1:27017/admin?authSource=admin"
  7. 启动svn
  8. svnserve -d -r /www/svn/ro
  9. mysql -u 用户名 -p -e "SELECT * FROM 数据库名.表名" -B | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > 输出文件.csv
  10. db.user.find(
  11. { _id: 10001587 }
  12. )
  13. db.user.updateOne(
  14. { _id: 10001587 },
  15. {
  16. $set: {
  17. "medalManager.medalMap": {},
  18. }
  19. }
  20. );
  21. test2插入到test集合中
  22. db.getSiblingDB('test').集合.insertMany(
  23. db.getSiblingDB('test2').集合.find().toArray(),
  24. { ordered: false }
  25. );
  26. //设置hset全部key为指定value10001
  27. EVAL "local keys = redis.call('HKEYS', KEYS[1]); for i,key in ipairs(keys) do redis.call('HSET', KEYS[1], key, ARGV[1]) end; return #keys" 1 CUser_ServerId: 10001
  28. //将10005的值改成10001
  29. EVAL "local keys = redis.call('HKEYS', KEYS[1]); local count = 0; for i,key in ipairs(keys) do local value = redis.call('HGET', KEYS[1], key); if value == ARGV[2] then redis.call('HSET', KEYS[1], key, ARGV[1]); count = count + 1; end; end; return count" 2 CUser_ServerId: 10001 10005
  30. redis-cli -a "lVzYFQ2i6v" EVAL "local keys = redis.call('HKEYS', 'CUser_ServerId:'); local count = 0; for i,key in ipairs(keys) do if redis.call('HGET', 'CUser_ServerId:', key) == '10004' then redis.call('HSET', 'CUser_ServerId:', key, '10005'); count = count + 1; end; end; return count" 0
  31. lVzYFQ2i6v
  32. db.your_collection.updateMany(
  33. {}, // 空对象表示匹配所有文档
  34. {
  35. $set: {
  36. "your_field": 10001
  37. }
  38. }
  39. );
  40. db.user_info.updateMany(
  41. {
  42. "serverId": "10004" // 只匹配serverId为10003的文档
  43. },
  44. {
  45. $set: {
  46. "serverId": "10005"
  47. }
  48. }
  49. );
  50. 时空合服工具,新增level字段在user_info集合里
  51. // 检查当前数据库
  52. db.getName();
  53. // 切换到login数据库
  54. use m5_tk_login;
  55. // 检查players集合结构
  56. db.user_info.findOne();
  57. // 1. 先添加level字段(如果不存在)
  58. db.user_info.updateMany(
  59. { level: { $exists: false } },
  60. { $set: { level: 0 } }
  61. );
  62. print("已初始化level字段");
  63. // 2. 假设有两个服务器:s1和s2
  64. // 更新服务器s1的玩家等级
  65. var server1Db = db.getSiblingDB("m5_x1_game_10001");
  66. var loginDb = db.getSiblingDB("x5_tk_login");
  67. var count1 = 0;
  68. server1Db.user.find().forEach(function(doc) {
  69. var result = loginDb.user_info.updateOne(
  70. {
  71. _id: doc._id
  72. },
  73. {
  74. $set: {
  75. level: doc.playerManager.level,
  76. update_time: new Date()
  77. }
  78. }
  79. );
  80. if (result.modifiedCount > 0) {
  81. count1++;
  82. }
  83. });
  84. print("服务器s1更新完成,更新了 " + count1 + " 条记录");
  85. //备份mongo所有数据库
  86. mongo "mongodb://admin:rimZBP82Ia@localhost:27017/admin"
  87. db.createUser({
  88. user: "mongobackup",
  89. pwd: "Backup562221715", // 使用强密码
  90. roles: [
  91. { role: "backup", db: "admin" },
  92. { role: "clusterMonitor", db: "admin" },
  93. { role: "readAnyDatabase", db: "admin" }
  94. ]
  95. })
  96. mongodump --uri='mongodb://mongobackup:Backup562221715@localhost:27017' \
  97. --authenticationDatabase=admin \
  98. --out /backup/mongodb/
  99. # 启动 MongoDB 服务
  100. sudo systemctl start mongodb
  101. //全服务端口查看
  102. netstat -lntp
  103. /etc/systemd/system/mongodb.service
  104. [Unit]
  105. Description=MongoDB Database Server
  106. After=network.target
  107. [Service]
  108. Type=forking
  109. ExecStart=/usr/bin/mongod --config /www/server/mongodb/config.conf
  110. ExecStop=/usr/bin/mongod --shutdown --config /www/server/mongodb/config.conf
  111. Restart=always
  112. RestartSec=5
  113. LimitNOFILE=64000
  114. [Install]
  115. WantedBy=multi-user.target
  116. mongo安装
  117. # 创建安装目录
  118. mkdir -p ~/mongodb-install
  119. cd ~/mongodb-install
  120. # 下载 MongoDB 4.0 的 RPM 包(以下为示例,可能需要更新下载链接)
  121. wget https://repo.mongodb.org/yum/redhat/7/mongodb-org/4.0/x86_64/RPMS/mongodb-org-server-4.0.28-1.el7.x86_64.rpm
  122. wget https://repo.mongodb.org/yum/redhat/7/mongodb-org/4.0/x86_64/RPMS/mongodb-org-shell-4.0.28-1.el7.x86_64.rpm
  123. wget https://repo.mongodb.org/yum/redhat/7/mongodb-org/4.0/x86_64/RPMS/mongodb-org-tools-4.0.28-1.el7.x86_64.rpm
  124. wget https://repo.mongodb.org/yum/redhat/7/mongodb-org/4.0/x86_64/RPMS/mongodb-org-mongos-4.0.28-1.el7.x86_64.rpm
  125. # 安装依赖
  126. sudo yum install -y cyrus-sasl cyrus-sasl-gssapi cyrus-sasl-plain libcurl net-snmp openldap openssl
  127. # 安装 RPM 包
  128. sudo rpm -ivh mongodb-org-server-4.0.28-1.el7.x86_64.rpm
  129. sudo rpm -ivh mongodb-org-shell-4.0.28-1.el7.x86_64.rpm
  130. sudo rpm -ivh mongodb-org-tools-4.0.28-1.el7.x86_64.rpm
  131. sudo rpm -ivh mongodb-org-mongos-4.0.28-1.el7.x86_64.rpm
  132. # 创建数据目录
  133. sudo mkdir -p /var/lib/mongo
  134. sudo chown -R mongod:mongod /var/lib/mongo
  135. # 创建日志目录
  136. sudo mkdir -p /var/log/mongodb
  137. sudo chown -R mongod:mongod /var/log/mongodb
  138. # 备份原配置文件
  139. sudo cp /etc/mongod.conf /etc/mongod.conf.bak
  140. # 编辑配置文件
  141. sudo vi /etc/mongod.conf
  142. # 网络绑定(默认只允许本地访问)
  143. net:
  144. port: 27017
  145. bindIp: 127.0.0.1 # 如果需要远程访问,改为 0.0.0.0
  146. # 存储配置
  147. storage:
  148. dbPath: /var/lib/mongo
  149. journal:
  150. enabled: true
  151. # 日志配置
  152. systemLog:
  153. destination: file
  154. logAppend: true
  155. path: /var/log/mongodb/mongod.log
  156. # 进程管理
  157. processManagement:
  158. fork: true # 后台运行
  159. pidFilePath: /var/run/mongodb/mongod.pid
  160. # 安全配置(建议设置)
  161. security:
  162. authorization: enabled # 启用认证
  163. # 启动服务
  164. sudo systemctl start mongod
  165. # 设置开机自启
  166. sudo systemctl enable mongod
  167. # 查看服务状态
  168. sudo systemctl status mongod
  169. # 查看日志
  170. sudo tail -f /var/log/mongodb/mongod.log
  171. 春之歌redis:/usr/bin/redis-server 127.0.0.1:6379 文件保存在/var/lib/redis
  172. mongo:/usr/bin/mongod -f /etc/mongod.conf
  173. mysql:/usr/sbin/mysqld
  174. nginx:./nginx -c /usr/local/nginx/conf/nginx.conf