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

Appendix B. Manually upgrading moregroupware

Table of Contents

Upgrading from 0.6.2 to 0.6.3
Upgrading from 0.6.3 to 0.6.4(pl1)
Upgrading from 0.6.4pl1 to 0.6.5
Upgrading from 0.6.5 to 0.6.6
Upgrading from 0.6.6 to 0.6.7

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

[Important]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.

[Warning]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!

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
Additional Home Upgrading from 0.6.3 to 0.6.4(pl1)