Currently I am applying a new Drupal theme on an existing site. I have created a separate instance for Development and copied the live site database and started working.

The new theme requires many new features ( modules, blocks, views etc ). I am just writing down every thing and of-course I need to redo it on live site once the theming is completed.

Is it possible that my Dev database gets updated automatically if changes are made on live site?

So once the theming is finished, I can drop the live DB and replace with Dev DB? Seems like a dream to me ..

Any help ?

  • no , i am using Drupal 7. i would like the Development database to auto update with the changes being made in the live site , and at the same time i will keep working on development. Once i am done, i will replace live database with dev database.
    – brainHax
    Feb 7, 2017 at 14:11
  • correct me if I'm wrong, but I think there is something misleading in your question: it appears that you are not just "re-theming" the site (= change the look and feel of it, by changes to a Drupal theme), you're also working on "many new features" (maybe enable/disable contrib or custom modules, or creating/updatings views?). If my perception is right (is it?) then I'd avoid using the term "re theming", and simply call it something like "applying maintenance and/or improving the site". Feb 7, 2017 at 14:29
  • yes you are right. I am implementing a new design with many new features.
    – brainHax
    Feb 7, 2017 at 14:31

1 Answer 1


Is it possible that my dev database gets updated automatically if changes are made on live site ?

So once the theming is finished, i can drop the live DB and replace with Dev one:) Seems like a dream to me ..

Databases shouldn't be migrated up (ie dev -> prod), only down (ie prod -> dev). If you migrate a database up, you will overwrite anything new on the production server. For example, any new accounts, comments, pages, or anything else that is in the database.

If you use the Features module, it will allow you to migrate some database settings as code (a features module) that can potentially solve your issue. Or if you are on D8, you can export configuration and import it in the other site.

  • Thats why i am looking for some thing to sync my dev with live automatically.
    – brainHax
    Feb 7, 2017 at 12:30
  • Other than the features module, I don't know of anything that does this, which is why I mentioned that module.
    – Jaypan
    Feb 7, 2017 at 12:39
  • But if this questions ends up in using features, then it has been answered already: drupal.stackexchange.com/questions/39417/…
    – mchar
    Feb 7, 2017 at 12:57
  • No, i am still looking for DB Sync from Live to Dev ( one way )
    – brainHax
    Feb 7, 2017 at 13:05
  • As far as I know databases synchronisation does not exist on drupal, what does exist is drush aliases -which again imports data from one db to another, not sych- and rsync.
    – mchar
    Feb 7, 2017 at 13:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.