Demand analysis
With the increase of Zen data, the MySQL server provided by virtual machine could not keep pace with the demand. And the original Zen Road front end and database separation installed in Windows and Linux, now provide physical server, need to move the Zen Road environment.
Confirm Environment Information
ip |
system version |
sql version |
role |
192.168.1.249 |
CentOS 6.4 |
5.6.28- Log MySQL |
old server |
192.168.35.130 |
CentOS 7.2 |
10.1.22-mariadb |
New server |
Steps to install the same version of Zen Road in Linux Server one-click installation package
Restore data
- Upload a Windows attachment (zentao\www\data\upload\1) backup to a Linux server, overwriting the appropriate directory file,/OPT/ZBOX/APP/ZENTAO/WWW/DATA/UPLOAD/1
- Export data (old database)
-
$/usr/local/mysql/bin/mysqldump-s/data/mysql/mysql3307/tmp/mysql.sock-h192.168.1.249-master-data=2- Single-transaction-default-character-set=utf8-uroot-p Zentao > Zentao.sql
- Error:
ERROR 1194 (HY000): Table ' Zt_file ' is marked as crashed and should be repaired
- Workaround:
REPAIR TABLEzt_file
- Import data (New database)
- Mysql-u Root-p < Zentao.sql
Restart Service Zen Road use
?
Zen Path Migration (windows_to_linux)