Upgrading the database

From WeBWorK_wiki
Revision as of 12:32, 21 March 2008 by Sam (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Just to clarify slightly, when you upgrade to 2.3, you'll also need to run wwdb_check before running wwdb_upgrade. wwdb_check brings the database into a consistent state ("version 0") so that wwdb_upgrade can then do automatic upgrades. You only need to run wwdb_check when upgrading an existing database from version 2.1.x or 2.2.x to version 2.3.x. Once you've reached 2.3.x, wwdb_upgrade will be able to handle future database updates.

Ad-hoc database update scripts for 2.1.x and 2.2.x
  • wwaddindexing — Add indexes to courses originally created with the sql database layout.
  • wwdb_addgw — Add gateway testing fields to courses created with WeBWorK 2.2.x.
New upgrade scripts for 2.3.x and later
  • wwdb_check — Bring database up-to-date for version 2.3.0. Run this only when upgrading from 2.1.x or 2.2.x to 2.3.x.
  • wwdb_upgrade — Run this when creating a new database for 2.3.x or later, after running wwdb_check, or when upgrading from an earlier version in the 2.3.x or 2.4.x series.