update.txt

tinypm敏捷开发工具是一界面简单功能齐全的敏捷开发工具 适合初学者使用

tinyPM - Tiny Effort, Perfect Management
=========================================================
version 1.2, October 2008

Backup
----------------------------------------------------------
1. Always remember to backup your database before upgrading  tinyPM to a newer version. 
   In MySQL you can do that using the following command:

     mysqldump --opt -u root -p --database tinypmdb > tinypmdb.sql
	
   or (if you have gzip tool available):

	 mysqldump --opt -u root -p --database tinypmdb | gzip -c9 > tinypmdb.sql.gz
	 
   All the data including the wiki pages attachments are stored in the database.
   The above instructions will backup all that data, so it's basically all you need
   to keep your tinyPM data safe.

2. You can also backup your context.xml file to avoid loosing you database connection
   settings as it will be removed during the update procedure:
   
     %CATALINA_HOME%/webapps/tinypm/META-INF/context.xml


tinyPM Update
----------------------------------------------------------

1. Stop your Tomcat server (we do not recommend using auto deployment on running Tomcat).

2. Run update script on your tinyPM database:
   
     \u tinypmdb
     \. %PATH_TO_INSTALL_FOLDER%/database/mysql/update_from_1.1_to_1.2.sql
     
3. Go to your tinyPM webapp directory and remove all its contents, 
   so that the directory %CATALINA_HOME%/webapps/tinypm is empty.
   
4. Unzip new tinypm.war to your %CATALINA_HOME%/webapps/tinypm directory.
   
5. Copy your backup context file into:

     %CATALINA_HOME%/webapps/tinypm/META-INF/context.xml
     
   If you didn't do a backup, you need to edit the context file and setup your
   database connection settings again.
     
6. Start your Tomcat server.
   Congratulations! Your new tinyPM version is up and running!