Migrating Your Horde Database Histories to a New Horde Database Table

Copyright (c) 2009 by Parallels

Please report all bugs and issues through the following feedback form: http://www.parallels.com/en/psoft/feedback.

Parallels H-Sphere documentation is available at http://www.parallels.com/en/products/hsphere/docs.

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:

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:
  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.

Contact Information

Parallels Holdings
660 SW 39th Street
Suite 205
Renton, Washington 98057
USA

Phone: +1 (425) 282 6400
Fax: +1 (425) 282 6444

Web: http://www.parallels.com/

E-mail:
For billing information, email accounting@parallels.com
For purchasing or partnering information, email sales@parallels.com
To report problems with Parallels software, email bugreport@parallels.com
For information on career opportunities with Parallels, email careers@parallels.com
For press contact information, email press@parallels.com
For information about becoming a Partner, email partners@parallels.com
For information on translating into your language, email i18n@parallels.com
For general product information, email info@parallels.com

© Copyright 2009 Parallels. All rights reserved.