Sorry, I didn't express myself properly the first time.  I meant that we have a
development server, where we are building separate sites for about a dozen
customers.   We would like to dump only the pages for one customer's site,
along with its associated styles, pages, page elements, etc.  This is
complicated by the fact that we use some style elements for all customers.  The
only solution I can think of is a Perl script which starts with a list of
hosts, then recursively dumps (using mysqldump with -w option to specify
particular rows) to a file all pages, elements and styles linked to that host's
root page.

Thanks,
Paul Gillingwater

Emiliano wrote:

> > I looked there, but only saw upgrade-base*.sql, which seems to alter the
> > tables.  I'm looking to move a single site from one Midgard server to
> > another.
>
> Without an upgrade? Why not just dump the database & reload at the other
> side?
>
> > Hints welcome, for example, do you have an Entity-Relationship model
> > for the Midgard database somewhere, so I can write code to follow a host,
> > topic and articles?
>
> Good idea actually. Anyone have experience with database modeling tools?
> Ehm, except NIAM. NIAM needs to die. Sorry folks, youth trauma time.
>
> 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]
begin:vcard 
n:Gillingwater;Paul
tel;cell:+43 699 1 922 3085
tel;home:+43 1 922 3084
tel;work:+43 1 2600 22950
x-mozilla-html:TRUE
url:http://actrix.co.at
adr:;;Schiffmuehlenstrasse 94/7/7;Vienna;;;Austria
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Paul Gillingwater
end:vcard

--
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