Upgrading from 0.6.6 to 0.6.7
Prev Appendix B. Manually upgrading moregroupware Next

Upgrading from 0.6.6 to 0.6.7

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

  1. Backup your 0.6.6 directory!!!

    cd /one/folder/above/moregroupware

    cp -R moregroupware moregroupware.bak

  2. Backup your database!!!

    mysqldump --add-drop-table -a -u [user] -p [dbname] > ~/mgw066.sql

  3. Get the new release from sourceforge.net.

  4. Unpack the files from the archive.

    cd /one/folder/above/moregroupware

    tar xzf moregroupware_0_6_7.tar.gz

  5. There are a few changes that need to be done to the config.inc.php file.

    The following lines need to be added and/or changed. The first two may seem less important, but at least the version is needed for correct bug reports. 

    $appconf["mgw_version"] = "0.6.7 - Spring";
$appconf["mgw_releasedate"] = "200304xx";
$appconf["def_language"] = "en";

$appconf["use_ntlm_auth"]= "";
$appconf["encrypt_pwd"]= "0";

define("SETUP_RUNNING", false);
define("LANG_DEBUG", false);

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

    [Important]Important

    There will be errors, so redirect the output somewhere you can easily read it! You will need to fix some things manually (e.g. duplicate keys, remove the old entry in such cases, and similar things)!

    mysql -u [user] -p [dbname] < mgw066-mgw067.sql

    Here is the SQL mentioned above:

    ALTER TABLE mgw_contacts DROP COLUMN keyType; # was varchar(150) default NULL
ALTER TABLE mgw_contacts ADD COLUMN keytype varchar(150) default NULL;

ALTER TABLE mgw_files CHANGE COLUMN name name varchar(255) default NULL; # was varchar(50) default NULL
ALTER TABLE mgw_files CHANGE COLUMN mime_type mime_type varchar(70) default NULL; # was varchar(20) default NULL
ALTER TABLE mgw_files ADD COLUMN size int(11) NOT NULL default '0';

ALTER TABLE mgw_todo ADD COLUMN startdate timestamp(14) NOT NULL;
ALTER TABLE mgw_todo ADD COLUMN starttype char(1) default '1';

CREATE TABLE mgw_instmsg (
  id int(11) NOT NULL default '0',
  sender int(11) NOT NULL default '0',
  recipient int(11) NOT NULL default '0',
  subject varchar(255) NOT NULL default '',
  message text NOT NULL,
  status char(1) NOT NULL default 'N',
  PRIMARY KEY  (id),
  KEY mimrecidx (recipient),
  KEY statidx (status)
);

CREATE TABLE mgw_log (
  id int(11) NOT NULL default '0',
  sort int(11) NOT NULL default '0',
  session varchar(128) NOT NULL default '',
  stamp int(11) NOT NULL default '0',
  level int(11) NOT NULL default '1',
  module varchar(30) NOT NULL default 'general',
  line int(11) NOT NULL default '0',
  file varchar(255) NOT NULL default '',
  message text NOT NULL
);

CREATE TABLE mgw_notes_comments (
  id int(11) NOT NULL default '0',
  note_id int(11) NOT NULL default '0',
  comment text NOT NULL,
  lu_update timestamp(14) NOT NULL,
  lu_user int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
);

CREATE TABLE mgw_notifications (
  id int(11) NOT NULL default '0',
  sender int(11) NOT NULL default '0',
  recipient int(11) NOT NULL default '0',
  message text NOT NULL,
  PRIMARY KEY  (id),
  KEY notrecidx (recipient)
);

INSERT INTO mgw_config VALUES (0,'enable_logging',1,'',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_admin',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_admin',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_admin',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_overview',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_overview',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_overview',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_settings',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_settings',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_settings',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_calendar',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_calendar',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_calendar',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_contact',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_contact',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_contact',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_files',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_files',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_files',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_forum',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_forum',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_forum',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_headline',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_headline',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_headline',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_news',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_news',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_news',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_notes',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_notes',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_notes',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_outboard',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_outboard',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_outboard',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_partprog',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_partprog',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_partprog',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_projects',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_projects',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_projects',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_todo',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_todo',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_todo',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_tts',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_tts',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_tts',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_webmail2',1,'',16,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_webmail2',2,'',8,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'log_webmail2',3,'',4,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'notify_js',1,'',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'notify_html',1,'',1,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'notify_mim_iframe',1,'',1,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'notify_mim_refresh',1,'',60,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'notify_mim_alert',1,'',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'notify_mail_from',1,'noreply@mgw.invalid',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'overview_get_modules',1,'news',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'overview_get_modules',2,'todo',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'overview_get_modules',3,'calendar',0,'',1,20020101000000);

INSERT INTO mgw_config VALUES (0,'calendar_notification',1,'',1,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'calendar_notification',2,'',6,'',1,20020101000000);

INSERT INTO mgw_config VALUES (0,'files_forbidden_mime',1,'application/x-msdos-program',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'mime_deb_binary',1,'/usr/bin/dpkg',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'mime_enscript_binary',1,'/usr/bin/enscript',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'mime_mp3_binary',1,'/usr/bin/mp3info',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'mime_msexcel_binary',1,'/usr/bin/xlhtml',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'mime_mspowerpoint_binary',1,'/usr/bin/ppthtml',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'mime_msword_binary',1,'/usr/bin/wvHtml',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'mime_rar_binary',1,'/usr/bin/rar',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'mime_rpm_binary',1,'/usr/bin/rpm',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'mime_tgz_binary',1,'/bin/tar',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'mime_zip_binary',1,'/usr/bin/zipinfo',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (3,'def_module',1,'forum',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (4,'def_module',1,'forum',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forum_posts_per_page',1,'',5,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forum_replies_per_page',1,'',5,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forum_pages',1,'',5,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forum_threads_viewtime',1,'',30,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forum_animatedgifs',1,'',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forum_signature',1,'',0,'This is the default Signature',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forum_mylogo',1,'',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forumgen_withmoderator',1,'',1,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forumgen_withsignature',1,'',1,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forumgen_withlogos',1,'',1,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forumgen_editownthreads',1,'',1,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forumgen_withemailnotify',1,'',1,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forumgen_mailsubject',1,'Default email subject',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forumgen_mailfromname',1,'Moregroupware_System',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forumgen_mailfromadress',1,'default@someadress.com',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forumgen_footeremailnotice',1,'some other email adress could be here',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'forumgen_footerhpnotice',1,'some homepage informations could be here',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'headline_proxy',1,'',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'headline_version',1,'062',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'overview_news',1,'',5,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'overview_notes',1,'',5,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'notes_enable_comments',1,'',1,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'todos_per_page',1,'',10,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'todo_merged',1,'',1,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'todo_overview_unstarted',1,'',0,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'todo_notification',1,'',1,'',1,20020101000000);
INSERT INTO mgw_config VALUES (0,'todo_notification',2,'',6,'',1,20020101000000);

INSERT INTO mgw_configtags VALUES ('enable_logging','*','global enable logging',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_admin','*','admin module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_overview','*','overview module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_settings','*','settings module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_calendar','*','calendar module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_contact','*','contact module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_files','*','files module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_forum','*','forum module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_headline','*','headline module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_news','*','news module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_notes','*','notes module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_outboard','*','outboard module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_partprog','*','partprog module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_projects','*','projects module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_todo','*','todo module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_tts','*','tts module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('log_webmail2','*','webmail2 module logging level',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('notify_js','*','enable js notification',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('notify_html','*','enable html notification',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('notify_mim_iframe','*','enable iframe for MIM',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('notify_mim_refresh','*','MIM refresh interval',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('notify_mim_alert','*','enable alert for MIM',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('notify_mail_from','*','mail notification sender mail',1,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('overview_get_modules','overview','What modules show in overview',1,1,'str',1,20020101000000);

INSERT INTO mgw_configtags VALUES ('calendar_notification','calendar','notification for calendar',1,1,'int',1,20020101000000);

INSERT INTO mgw_configtags VALUES ('use_dialer','contact','1 if dialer is to be shown, 0 if not',0,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('files_forbidden_mime','*','forbidden MIME types',1,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_deb_enable','*','enable mime viewer',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_enscript_enable','*','enable mime viewer',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_mp3_enable','*','enable mime viewer',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_msexcel_enable','*','enable mime viewer',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_mspowerpoint_enable','*','enable mime viewer',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_msword_enable','*','enable mime viewer',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_rar_enable','*','enable mime viewer',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_rpm_enable','*','enable mime viewer',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_tgz_enable','*','enable mime viewer',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_zip_enable','*','enable mime viewer',1,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_deb_binary','*','mime viewer binary',1,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_enscript_binary','*','mime viewer binary',1,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_mp3_binary','*','mime viewer binary',1,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_msexcel_binary','*','mime viewer binary',1,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_mspowerpoint_binary','*','mime viewer binary',1,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_msword_binary','*','mime viewer binary',1,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_rar_binary','*','mime viewer binary',1,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_rpm_binary','*','mime viewer binary',1,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_tgz_binary','*','mime viewer binary',1,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('mime_zip_binary','*','mime viewer binary',1,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forum_posts_per_page','forum','nr of posts per page in forum',0,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forum_replies_per_page','forum','how many replies per page in forum',0,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forum_pages','forum','nr of forum pages',0,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forum_threads_viewtime','forum','how many days a thread should be visible',0,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forum_animatedgifs','forum','use animated gifs in forum',0,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forum_signature','forum','your signature',0,0,'txt',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forum_mylogo','forum','your personal logo',0,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forumgen_withmoderator','forum','with moderators',0,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forumgen_withsignature','forum','with signatures',0,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forumgen_withlogos','forum','with Logos',0,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forumgen_editownthreads','forum','if users can edit their own threads',0,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forumgen_withemailnotify','forum','with email remind on new posts',0,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forumgen_mailsubject','forum','subject of email',0,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forumgen_mailfromname','forum','name of mail sender',0,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forumgen_mailfromadress','forum','emailadress of sender',0,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forumgen_footeremailnotice','forum','footer information regarding email',0,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('forumgen_footerhpnotice','forum','footer information regarding homepage',0,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('headline_proxy','headline','proxy setting for headline',0,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('headline_version','headline','',0,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('overview_news','news','numer of news to show in overview',0,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('overview_notes','notes','numer of notes to show in overview',0,0,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('notes_orderby','notes','default order of notes',0,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('notes_order_dir','notes','order asc or desc',0,0,'str',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('notes_enable_comments','notes','allow comments on notes',0,0,'int',1,20020101000000);

INSERT INTO mgw_configtags VALUES ('todo_notification','todo','notification for delegaded todos',1,1,'int',1,20020101000000);
INSERT INTO mgw_configtags VALUES ('todo_overview_unstarted','todo','show unstarted todos in overview',0,0,'int',1,20020101000000);
    [Important]Important

    If you have been using the webmail2 module, read the webmail2 update manual in MGW_0-66_to_0-67_Webmail_Update_manual.pdf in modules/webmail2/docu/!

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

  8. If all is up and running, you can safely delete the backup files 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 -e "DROP DATABASE [dbname]"

mysql -u [user] -p -e "CREATE DATABASE [dbname]"

mysql -u [user] -p [dbname] < mgw066.sql

Prev Up Next
Upgrading from 0.6.5 to 0.6.6 Home Appendix C. Using DocBook XML for documentation