Back up MySQL in ZenTao

2019-01-09 10:59:00

This instruction applies to server change from Windows to Linux.

Download a one-click installation package for Linux, and unzip it to /opt.

cd /opt wget

tar zxvf ./

Visit the directory and start ZenTao .

cd ./zbox ./zbox start

But! You will find nothing in the database. Don't panic. According to the official manual, you can back up your ZenTao MySQL and restore it in your new database.

Run the script to back up.

I:\xampp\zentao\bin>i:\xampp\php\php.exe I:\xampp\zentao\bin\php\backup.php

You will get two .zip file. One is for MySQL, the other is all the files uploaded. Store the two files in /opt/zbox/app/zentao/www/data/upload/1 and keep the original directory.

Pass MySQL script to the root directory of Linux and run the command below.


Import .sql file in MySQL command line.

use zentao;

source db.20160529.sql;

Done! Now you can visit ZenTao using the IP address you used before.

Write a Comment
Comment will be posted once reviewed.

Why choose ZenTao


Serving 30,000+ teams

Serving 200,000+ projects

Serving 800,000+ developers

The #1 in local market share

Free & Open

Open source and unlimited to commercial

Powerful extension mechanism and various plug-ins

Available on Github

Either Self-Host or Cloud Apps


Refined ALM support

Zero downtime upgrades 

Integrate Git and SVN (pro)

Word and Excel import & export (pro)

Preview-Edit-Diff document online(ent)

Integrate OPS-Attendance-Feedback(ent)


ZenTao team has involved in open source since 2004

Frequent releases and free upgrade forever(even self-hosted) 

Instant and powerful support for 20000+ companies


Out of the box, Less config

Nice price for small team($9.9)

Design to adhere Scrum Best practice

For Agile but not restrict to Agile


Applicable for different sized teams

Applicable for Agile/Waterfall

Modules can be used in any combination

Convenient customization