3. Backup the database
At this point all you have done is preparation. Do make sure nobody else is busy working in OpenX, adding any inventory for instance. Now make a full backup of the database that stores your OpenX information., and also check the resulting backup file to make sure it’s complete.
OpenX databases tend to become rather large over time. So in addition to making a backup, you should also think about a way of restoring that backup. A nice little tool to restore a very large database backup is called ‘big dump‘ (a free download). It comes with some instructions.
The OpenX upgrader normally creates backup versions of all the tables in your OpenX database. These backup tables are used to attempt a recovery when the upgrade goes wrong in any way. But since you already have a full database backup, there is a little trick to make the next step work a little bit faster and with less overhead by not creating these backup tables. The trick is to put a file named “NOBACKUPS” in the ‘var’ folder just below your ‘openx_new’ folder. The file can be completely empty, it’s just the name and the fact that it’s there that tell the upgrader to skip creating backup tables. It does mean though that when something does go wrong during the upgrade (unlikely but still possible) you’ll have restore everything manually (that’s why I do a full database backup manually just before upgrading).
MyTestBox.com - web software reviews responded on 17 Jul 2008 at 12:13 am #
[...] Strategy for upgrading OpenX (courtesy of Erik Geurts) [...]
OpenX tips by Erik Geurts responded on 10 Oct 2008 at 1:42 am #
OpenX version 2.6.2 released…
Earlier in the week, an important upgrade to OpenX 2.6 was released. This version 2.6.2 fixes a security issue that was reported a few days ago. Because of this, it’s very important that all users of OpenX 2.6 upgrade their installations. To down…