Updating standalone (for Windows)

Contents

Updating tinyPM Standalone

Remember to backup your data!
Always remember to backup your database and configuration files before updating tinyPM installation!
See also:
We use %TINYPM_PATH% to refer to a base tinyPM installation path (for example C:\Program Files\tinyPM). You don't need to set such environment variable anywhere. It's used only for the purpose of this documentation.

Updating application

1. Stop tinyPM Standalone if it's running.

2. Run tinyPM installer and install new tinyPM version in the same directory as your old version.

After successful installation you may need to upgrade your tinyPM database (see next steps below). But it's required only if the new version contains an update script. Starting from v2.5.2 you can check what scripts should be used to update your database by using the following command: 
java -jar %CATALINA_HOME%/webapps/tinypm/WEB-INF/lib/tinypm.jar --scripts=<your_current_tinypm_version>

Updating tinyPM database

HSQLDB

1. Stop tinyPM Standalone if it's running.

2. Run tinyPM Database SQL tool. You will find a link in START menu. If you didn't create menu shortcuts during installation run (your working directory should be %TINYPM_PATH%):

%TINYPM_PATH%\bin\hsqldb.bat

3. Run all required update scripts by executing the following commands (choose update scripts proper for the version you are upgrading from):

HSQLDB console
\i sql/hsqldb/update_from_2.4_to_2.4.1.sql
\i sql/hsqldb/update_from_2.4.1_to_2.5.sql

4. Quit SQL tool using \q command.

5. Start tinyPM standalone.

MySQL

1. Stop tinyPM Standalone if it's running.

2. Run MySQL command line tool (i.e. using mysql -u root -p).

3. Select your tinyPM database (tinypmdb by default) and run all required update scripts:

MySQL console
   
\u tinypmdb
\. %TINYPM_PATH%/sql/mysql/update_from_2.4_to_2.4.1.sql
\. %TINYPM_PATH%/sql/mysql/update_from_2.4.1_to_2.5.sql

4. Quit SQL tool using \q command.

5. Start tinyPM standalone.

Congratulations! Your new tinyPM version is up and running!

Troubleshooting

By default tinyPM uses ERROR logging level to avoid flooding your log files. If you have problems with your tinyPM installation you can change logging level to a more verbose INFO level by editing Log4J settings in:

%TINYPM_PATH%/webapps/ROOT/WEB-INF/classes/log4j.properties
? If this documentation doesn't solve your problem or has left you with any questions, please don't hesitate to contact us at support@tinypm.com
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.