Zen Path Migration (windows_to_linux)

Source: Internet
Author: User
Tags import database

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
    • Unzip to opt directory TAR-ZXVF zentaopms.9.6.2.zbox_64.tar.gz-c/opt

    • Apache and MySQL Start-stop

      • Execute the/opt/zbox/zbox start command to open Apache and MySQL.
      • Execute the/opt/zbox/zbox stop command to stop Apache and MySQL.
      • Execute the/opt/zbox/zbox restart command to restart Apache and MySQL.
      • /opt/zbox/zbox-ap 8080-MP 3307
        • AP parameter can modify Apache port
        • MP parameter to modify the MySQL port
      • If you need to start the boot automatically, you can add the/opt/zbox/zbox restart to the operating system's self-starter directory.
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
  • Access and Login Zen Trails

    • Once the Apache and MySQL services are launched, the browser accesses and logs into Zen Road directly by accessing the http://Zen Channel Server Ip:apache port.
    • Note: If the webpage is inaccessible, please turn off the firewall of the computer where Zen Tao is located and then refresh the page access by SELinux.
    • Zen Road Default Admin account is admin, password 123456.
  • Zen Trail Database

    • Web Login database

      • Zen Path database management is Adminer, but for security, access to Adminer requires authentication and needs to run/opt/zbox/auth /adduser.sh to add users (cd/opt/zbox/auth/and then execute./adduser.sh)
      • Web Access to http:/Zen Lane Service IP Apache Port, click on the "Database Management" button has 2 layer authentication:
        • Popup validation is the input run Addusers.sh added username and password
        • Web page directly displays the login interface:
          • system: MySQL is selected by default.
          • server: 127.0.0.1:mysql port
          • user name: root
          • password: 123456
          • database: Zentao
    • Command line Connection Database

      • Login database:/opt/zbox/bin/mysql-u root-p mysql Port-P (example:/opt/zbox/bin/mysql-u root-p 3306-p)
      • Import Database:/opt/zbox/bin/mysql-u root-p MySQL Port-p to import the library name < Xxxx.sql (for example:/opt/zbox/bin/mysql-u root-p 3306-p Zentao < ; Zentao.sql)
      • Linux Database storage directory: Opt/zbox/data/mysql/zentao
?

Zen Path Migration (windows_to_linux)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.