>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 12/28/00, 12:51:51 AM, Fred Hirsch <[EMAIL PROTECTED]> wrote regarding 
[midgard-user] Oddities with Repligard:

> I figure this is a result of my consistently upgrading through the beta
> cycles, but possibly not upgrading the database along side it. 

Very likely, yes. Probably you have an incorrect repligard table.

> I did get
> Asgard to install just fine using a blank install. I also cannot get
> Repligard to export my current DB, so I will probably just work on 
piecing
> my database backup back into Midgard a piece at a time using a secondary 
DB
> and then export it into the main DB.

You could try this:

mysqldump -u root -p --no-create-info midgard > mgd.sql

edit mgd.sql, deleting every 'INSERT into repligard' statement.
If the 'INSERT into sitegroup' lines have only three fields, add a realm 
field.

Example: 
   INSERT into sitegroup (1,'example',60); 
-> INSERT into sitegroup(1,'example','example realm',60);

mysqladmin -u root -p create midgard-new

mysql -u root -p midgard-new < empty.sql 

empty.sql coming from the midgard-1.4 datapackage.

mysql -u root -p midgard-new < mgd.sql

Once you get here, your database is in a consistent 1.4 shape, and you 
should have no problems installing Asgard.

Armand.


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

Reply via email to