Appendix B. Manually upgrading moregroupware
Prev | Part V. Appendices | Next

## Appendix B. Manually upgrading moregroupware

This appendix contains the instructions for manually upgrading moregroupware, as they have been posted to the mailing lists.

| Important
If you need to upgrade from e.g. 0.6.4 to 0.6.6, you need to perform the upgrade in two steps, from 0.6.4 to 0.6.5 and finally to 0.6.6. This is true for all versions!

| Warning
You should only attempt an upgrade if you still feel comfortable after(!) reading the instructions. You need some knowledge of what you are doing. It worked for the author, but no warranty is given whatsoever!

## Upgrading from 0.6.2 to 0.6.3

Here is what to do (Unix style, log in to server first):

1. Backup your 0.6.2 directory, just to make sure!

   `cp -R moregroupware moregroupware.bak`

2. Backup your database, just to make sure!

   `mysqldump --add-drop-table -a -u [user] -p [dbname] > mgw062.sql`

3. Get the new release.

   `wget http://prdownloads.sourceforge.net/moregroupware/moregroupware_0_6_3.tar.gz`

4. Unpack the files from the archive, overwriting the old stuff.

   `cd /one/folder/above/moregroupware`

   `tar xzf moregroupware_0_6_3.tar.gz`

5. You need to adjust the database now. The SQL that is shown below needs to be inserted into the database.

   `mysql -u [user] -p [dbname] < mgw062-mgw063.sql`

   Here is the SQL mentioned above:

                 ALTER TABLE mgw_todo ADD COLUMN priority char(1) default '3';
                 INSERT INTO mgw_configtags VALUES (55,'show_company_id','1','1 if company id is to be shown, 0 if not','0','0','int','','');
                 INSERT INTO mgw_configtags VALUES (56,'todo_orderby','3','default order of todos','0','0','str','','');
                 INSERT INTO mgw_configtags VALUES (57,'todo_order_dir','3','order asc or desc','0','0','str','','');
                 INSERT INTO mgw_configtags VALUES (58,'todo_merged','3','showin todos merged','0','0','int','','')

6. Now log in and verify everything works as expected (or at least as good as before...).

7. If all is up and running, you can safely delete the files backup and the SQL dump created in steps 1 and 2.

If you run into trouble, you can revert back to the old release by removing the new moregroupware directory, moving back the backup dir and just piping the backup SQL into the database:

`rm -ri moregroupware`

`mv -i moregroupware.bak moregroupware`

`mysql -u [user] -p [dbname] < mgw062.sql`

Prev | Up | Next
Miscellaneous | Home | Upgrading from 0.6.3 to 0.6.4(pl1)