Re: [midgard-user] Midgard 1.4 stable release

[Philipp Rotmann, Linksystem Muenchen]

     Hi Alex, 

thanks for your suggestion -- but firsthand, it seems to me that
the current state of my Midgard database is not fully consistent
with your assumptions (after database-upgrade and one partially
failed execution of dbinstall) ... therefore, I'm describing
some of my observations below and wait for your 'go!' before
I'll actually change something.

On 29.12.00 (20:55), Alexander Bokovoy wrote:
> 1. Backup database

Done already before the upgrade, of course.

> 2. Using mysql console, rename Asgard's components (Root
>    pages, Styles, /Asgard snippetdir) to different names,
>    change host info.

My 'page' table features lots of empty records (to be exact, 52
records with only id, up=0, style=0, author=0, changed=
0000-00-00 and sitegroup=0 set -- which are the defaults). No
Asgard pages have been installed, only two new pages for the old
Adminsite (snippetdir and snippet).

My 'style' table surprisingly does feature Asgard records --
but for every Asgard record ('Asgard' .. 'Asgard Main Frame',
four of them) there's one empty record as well.

The 'snippetdir' table is totally empty, as well as the
'snippet' table; there is no Asgard record in the 'host' table.

> 3. Check for correct Repligard table in your database;

That would be this one:

| mysql> describe repligard;
| +-----------+-------------+------+-----+---------------------+-------+
| | Field     | Type        | Null | Key | Default             | Extra |
| +-----------+-------------+------+-----+---------------------+-------+
| | id        | int(11)     |      |     | 0                   |       |
| | timestamp | datetime    |      |     | 0000-00-00 00:00:00 |       |
| | updated   | datetime    |      |     | 0000-00-00 00:00:00 |       |
| | realm     | varchar(32) |      |     |                     |       |
| | tag       | varchar(32) |      | MUL |                     |       |
| | sitegroup | int(11)     |      |     | 0                   |       |
| +-----------+-------------+------+-----+---------------------+-------+
| 6 rows in set (0.00 sec)

> 4. run 'delete from repligard;' in mysql's console;
> 5. Install new Asgard.
> 6. Run 'repligard -m' for this database;
> 7. Delete old Asgard's components from new Asgard interface.
> 8. Export your database using Asgard and delete from XML file
>    all records with attribute 'deleted="<SOME-DATE>"'

... and re-import the XML file, I guess.

> I can't give you guarantie that it will work but I've used it
> myself. Step 2 needed to recognize old records after
> installation, steps 3 and 4 are most important, step 6 will
> regenerate GUIDs for your data (and old Asgard code which
> you'll delete at step 7). Step 8 is for safety.

     phr
-- 
Linksystem Muenchen GmbH                          [EMAIL PROTECTED]
Schloerstrasse 10                           http://www.link-m.de
80634 Muenchen                              Tel. 089 / 890 518-0
We make the Net work.                       Fax 089 / 890 518-77

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]