On Tue, Jun 15, 2004 at 07:33:32PM +1000, Tony wrote:
Guido Holz asked how to adapt the database from
mediawiki 1.2.6 to phase3, as there are more tables and columns in
Phase 3 than in 1.2.x.
JeLuF replied: The install script updates the database.
Nope. Not always.
Despite considerable effort, I was unable to get the install script
to work with an existing 1.2.x database. The problem *may*
be to do with not having the right permissions. Or it may be something else entirely.
[...]
If you are installing a version that uses the same database format
as your previous install (e.g., old install and new install are
both 1.2.4 - probably OK with any pair of 1.2.x versions), you can
simply restore your backup over the top of your brand-new
empty database and everything works fine. (You may have to hit SHIFT-RELOAD
in your browser to clear the caches before
it looks right).
If your backup is from 1.2.x and you have installed 1.3.x, then a restore
will promptly crash and burn. (Trust me: I've tried it.)
You need to transform the database to the new format first! At present,
this does not seem to be possible for non-SQL gurus.
The installer converts the database only if it already exists. So restore your
database first (to the empty DB) and call the installer afterwards, pointing
it to the DB.
JeLuF