Update data from live server data base to dev server data base

July 2, 2018 210 views
MySQL Ubuntu

Before migrating a new site from its development server to a live server, I need to copy the most updated data in live database to dev datbase (i.e users, bookings, posts...) I've checked several Wordpress plugins, but they mostly keep databases synced between servers, which will delete data in/from one side. However, since my dev and live server databases have different tables I need to update those tables in live server that are the same as in dev server. How can this be accomplished?

Be the first one to answer this question.