Version 1


Upgrading from other databases to bitweaver

Created by: xing, Last modification: 27 Oct 2005 (09:50 UTC) by xing
This page contains information on how to convert from databases such as tikiwiki to bitweaver.

Upgrade Gotcha's

  • You may need to increase your PHP.INI memory_limit value (up to 64M or more) and max_execution_time (to 180 seconds or more) during upgrades of large sites
  • Don't forget to reimport your customised styles into the themes/styles directory of the new installation
  • Don't forget to confirm your start page during the installation

Generic Database Upgrades / Conversions

bitweaver has a powerfull yet simple upgrader that is part of the InstallPackage. With a single click you can give your old site the power of bitweaver.

Our architecture for upgrading, like all of bitweaver, is modular and powerful. Every BitweaverPackage maintains its own upgrade script. This architecture enables you to upgrade *any* CMS to *any* bitweaver version. Anyone up for a drupal upgrader? *nuke upgrader? TW1.9 upgrader?

Currently it handles TikiWiki 1.8 and bitweaver ReleaseZero updates. It uses a lot of subselects so you will need a real database or at least MySQL 4.1.

How does it work?

install/upgrade.php does all the magic by looking at every BitweaverPackage's <package>/admin/upgrade_inc.php. This file has upgrade hashes of SQL *and* php for each package version and particular RDBMS as necessary. Below is a brief example. We suggest you look at liberty/admin/upgrade_inc.php if you are interested in seeing a complete example of how it works, or shoutbox/admin/upgrade_inc.php for a simpler example.

= array(

'TW18' => array(
'2.0' => array(
'pgsql' => 'ALTER TABLE tiki_pages RENAME `pageId` TO `page_id`'

'2.0' => array(
'3.0' => array(
'sql92' => "ALTER TABLE tiki_pages ADD foo VARCHAR(20); UPDATE tiki_pages SET foo='bar';",
'php' => 'foreach( $hash as $key ) { doSomething(); } '


Page History
18 May 2008 (20:35 UTC)
Current • Source
View • Compare • Difference • Source
View • Compare • Difference • Source