Patches&Updates Migrating your Horde DB histories to a new Horde DB Table



Horde 3.1.1 update incorporated into hsphere-webmails-h2.5-2-19 and hsphere-webmails-2-19 moves Horde_History storage out to a separate database table to drastically improve performance. While Horde DB table structure is updated automatically, to migrate your histories to a new table, you must execute the move_history_out_of_datatree.php PHP script:

php ~httpd/htdocs/horde/scripts/upgrades/move_history_out_of_datatree.php
php - standalone CLI php:
  • For HS 2.4.3, you have to install related OS system package, if absent.
  • For 2.5.0+:
    /hsphere/shared/php4/bin/php-cli
    or
    /hsphere/shared/php5/bin/php-cli

Procedure:

Migration of the Horde_History data may take very much time, possibly days, depending on the number of entries. Be sure to execute this script from a location where it will not be timed out by firewall or terminal timeouts:

  1. Check your firewall setting.
  2. To check the execution script timeout, find php.ini location for corresponding CLI php binary:
    • for HS 2.4.3:
      php -i | grep php.ini
    • for HS 2.5.0:
      /hsphere/local/config/httpd/php4/php.ini
      or respectively to php binary:
      /hsphere/local/config/httpd/php5/php.ini
  3. Go to Horde location
  4. cd ~httpd/htdocs/horde/
  5. Change the maximum execution time for php script, in seconds. If parameter is absent or too small, there are two ways to change it:
  6. Choice One:
    If php.ini conf file is used by apache php module, it's recommended to:

    1. Create a copy of this file
    2. cp -p /hsphere/local/config/httpd/php4/php.ini /hsphere/local/config/httpd/php4/php_copy.ini
    3. Edit this copy.
    4. vi /hsphere/local/config/httpd/php4/php_copy.ini
    5. Run script:
      /hsphere/shared/php4/bin/php-cli -c /hsphere/local/config/httpd/php4/php_copy.ini -f ./scripts/upgrades/move_history_out_of_datatree.php

    Choice Two:
    If all php.ini settings are proper and you want to change the max_execution_time parameter directly from command line, use common php.ini file by running:

    /hsphere/shared/php4/bin/php-cli -d max_execution_time=604800 ./scripts/upgrades/move_history_out_of_datatree.php

Read more about Using PHP from the command line.



Copyright 1998-2008. Positive Software Corporation.
All rights reserved.