ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

migrating from staging to live when live has user generated content that staging doesnt

May 24, 2011 4:23am

Subscribe [2]
  • #1 / May 24, 2011 4:23am

    michaeil

    3 posts

    Hi,

    I have a site that had to go live in two stages - the first stage had a competition and due to time constraints ( less than a day ) I opted to make a competitions entries channel that the users post the entires into, rather than a module and its own table which was my preferred solution.

    however i am now wondering how i get the new information from staging ( which has new articles posted into new categories/channels ) from staging to live - because of the link between channel_titles and channel_data, the ID’s wouldnt match between staging and live ( eg the articles are id 100, but live currently has over 4000 entries in it. I cant drop the table and re-import staging because we need the comp entries.

    Can I import everything but those tables using “drop table if exists” option in phpmyadmin, and then import those two tables with no ID field ? will this match channel_titles and channel_data ID’s ?

    or is there another way of doing this ?

    thanks for the advice

  • #2 / May 24, 2011 12:24pm

    Sue Crocker

    26054 posts

    Hi, michaeil.

    What I’d do is create an RSS feed and use DataGrab to import the extra items into your primary site.

    Does that help?

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases