"Armand A. Verstappen" wrote:

> I haven't, so your script would be more than welcome.

There is now a script available at
http://www.midgard-project.org/~emiliano/sg0migrate
Rather crude but it will do the job. It's short and simple and if your
admin site IDs have changed it will happily carry on.

This script uses perl and the MySQL DBD connector. It assumes that the
DB is in
1.4b3 state (event and sitegroup tables added); if the event tables are
missing you'll see harmless complaints.

This script moves all the content that wasn't in the default database to
sitegroup 1 (editable by changing $sitegroup in the script).

> It would also be great
> if the database upgrade would move all existing sites except the admin site
> to a sitegroup 'old' or something. But I suppose that would also only work
> if their have been no additions to the admin site?

You'll have to define the sitegroup yourself, so before running
sg0migrate you
could do INSERT INTO sitegroup (name) VALUES('old');, note the id and
fill that
in in the script.

Emile

--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org

To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]

Reply via email to