WordPress cicd database migration

  • bespokeeagle

    (@bespokeeagle)


    4 years, 3 months ago

    hello, I am fairly new to developing WordPress and I am wondering the best way to migrate the necessary tables in my database.
    I am using a ci process on Azure devops to handle the migration of files from local to live.
    I want to be able to update my live the dB and not overwrite it.
    Does anyone have any suggestions.
    I will like to know how and if this is possible
    If it is, i do i know the necessary tables to migrate.

    • This topic was modified 4 years, 3 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Developing with WordPress topic
Viewing 2 replies - 1 through 2 (of 2 total)
  • catacaustic

    (@catacaustic)

    4 years, 3 months ago

    Do you mean that you want to update your live sites database with anything that’s been updated on your dev site without changing anything that shouldn’t be changed on your live site?

    If that’s the case, you really won’t be able to do that. There’s no good tool or process available that can handle SQL queries to let you merge and update like that. There’s been many projects to try and make one, but so far nothing has come close to working correctly.

    The best thing to do is get your dev sites database to a point where it’s everything that you need it to be, and transfer that over to overwrite your live sites database, or go through your live site and make updates as needed to match the dev site.

    Thread Starter bespokeeagle

    (@bespokeeagle)

    4 years, 3 months ago

    @catacaustic thanks for the response i will look into that.

    I’m just worried about GDPR regulations concerning user data on dev and staging environments

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘WordPress cicd database migration’ is closed to new replies.