Book Image

Redmine Cookbook

By : Shamasis Bhattacharya
Book Image

Redmine Cookbook

By: Shamasis Bhattacharya

Overview of this book

In a variety of online project management tools, Redmine markets itself as offering flexibility. Choosing the right management tool can mean the difference between the success and failure of a project. Flexible project management tools bend themselves to fit your needs, whether that’s communication regarding a simple project, or collaboration, or more complex project methodology such as SCRUM, or an issue-code relationship, or the need of different methodology for your project. Whether you are project manager or system administrator, this book provides valuable recipes to get the best possible performance out of your team, organization, infrastructure, and Redmine itself. Through a series of carefully crafted recipes covering the nitty-gritty of Redmine, you’ll be guided through the installation of Redmine, as well as how to fine-tune and customize your Redmine installation. Finally, we walk you through integrating Redmine with other softwares and databases like Tortoise SVN and Visual Studio and troubleshooting Redmine.
Table of Contents (17 chapters)
Redmine Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface
Index

Upgrading or migrating the database behind Redmine


Dealing with production databases is always a risky process. Even if it's a minor upgrade from version x.01 to x.02, there is always a possibility that the database will stop working or data corruption will occur. Migrating databases also poses a data consistency risk. To avoid data loss, follow the instructions provided in this recipe, always use a test environment, and never delete backups until you are sure that the new system is working as expected, and you have a backup of your new system.

Getting ready

Before performing a database upgrade, make sure it is working with your Redmine's database drivers.

Follow the recipe Configuring Backup and Recovery to make a backup and take a snapshot of your virtual machine if possible.

How to do it…

To upgrade the database behind Redmine, make sure to create a backup before upgrading. As Redmine uses any of the following DBMS: MySQL, PostrgreSQL, MSSQL, and SQLite, you will need to consult your database...