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?

  • You can use a tool like phpMyAdmin to export just the tables that are the same, then import them into the other site. There are other more advanced tools like WP-CLI that can also accomplish this type of task. – WebElaine Jul 2 '18 at 16:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.