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.

Database issue when working on development and merging back to live

September 19, 2012 2:11am

Subscribe [2]
  • #1 / Sep 19, 2012 2:11am

    amimpact

    11 posts

    Hi, the problem that we are having is:
    We have a website running on a live environment, the owner
    contacts us and request if we can make a few changes to
    the site. We make a copy of the website (and database)
    we install some plugins, change some channels.

    We merge this back to the live environment, for the files
    this is not a problem git handles merging very well.
    The problem is the database, EE makes changes in the database
    and we haven’t found a way to solve this problem.

    We have looked at a few options:
    - Hook for CodeIgnite before it insert into the database. (Is not possible)
    - Hook for MySQL. (Trigger won’t be able to handle a complete database)
    - Binlog MySQL. (Not possible)
    - Catch all queries using mysql log. (Gives tons of useless data and kills performance)

    Has anyone fix this problem?
    or found a work around for this problem?

    - Ronald

  • #2 / Sep 20, 2012 3:59pm

    Shane Eckert

    7174 posts

    Hey amimpact,

    This is an age old issue with multi environments and database.

    As far as I know there is still no solution to this. You will need to stop production for a bit and import the changes from dev and then take production live again.

    Love you ideas, getting creative!

    Is there anything else I can help with?

    Cheers,

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

ExpressionEngine News!

#eecms, #events, #releases