Migrating your Horde DB histories to a new Horde DB Table - Positive Software Corporation

• 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
cd ~httpd/htdocs/horde/
4. Change the maximum execution time for php script, in seconds. If parameter is absent or too small, there are two ways to change it:

Choice One:
If php.ini conf file is used by apache php module, it's recommended to:

1. Create a copy of this file
cp -p /hsphere/local/config/httpd/php4/php.ini /hsphere/local/config/httpd/php4/php_copy.ini
2. Edit this copy.
vi /hsphere/local/config/httpd/php4/php_copy.ini
3. 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.