>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 1/11/01, 5:06:04 PM, Paul Newby <[EMAIL PROTECTED]> wrote regarding
[midgard-user] upgrading Midgard database from 1.4 beta:
> Has anyone sucessfully upgraded their midgard database
> from an early 1.4 beta (1.4b5, in my case) to 1.4 release?
> If so, I'd like to hear how you did it.
Yes, I did.
The beta series had a different layout for the repligard table, and the
sitegroup table didn't have the realm column. This how I worked around
the fact that the upgrade script misses these differences:
- mysqldump -u root -p --no-create-info midgard > export.sql
- edit export.sql, removing al data-entries for the repligard table.
- verify that the sitegroup table has the correct structure
(compare with create statement in empty.sql)
- if needed add realm values to export.sql
- mysqladmin -u root -p newmidgard
- mysql -u root -p newmidgard < export.sql
- edit install-repligard.conf to use database newmidgard in stead of
midgard.
- mysql -u root -p newmidgard < GUIDSforOLDSITE.sql
- repligard -c install-repligard.conf -m , to generate missing guids
- repligard -c install-repligard.conf -i AsgardSite.xml
- repligard -c install-repligard.conf -i asgard.fr_FR.xml (repeat for
every
language you want to install)
- give user that accesses midgard correct rights to access newmidgard in
mysql
- change MidgardDatabase line to use newmidgard instead of midgard.
- restart apache.
Let me know if that works for you.
Armand.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
