{"id":27483,"date":"2017-04-04T14:11:56","date_gmt":"2017-04-04T12:11:56","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=27483"},"modified":"2017-04-04T14:11:56","modified_gmt":"2017-04-04T12:11:56","slug":"how-to-synchronize-wordpress-live-and-development-databases","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2017\/04\/04\/how-to-synchronize-wordpress-live-and-development-databases\/","title":{"rendered":"How to Synchronize WordPress Live and Development Databases"},"content":{"rendered":"<!-- google_ad_section_start -->\n<p><a href=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2017\/04\/databases.jpg?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"27484\" data-permalink=\"https:\/\/mamchenkov.net\/wordpress\/2017\/04\/04\/how-to-synchronize-wordpress-live-and-development-databases\/database-and-networking-concept\/\" data-orig-file=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2017\/04\/databases.jpg?fit=775%2C480&amp;ssl=1\" data-orig-size=\"775,480\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;Oleksiy Mark - Fotolia&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;Database and networking concept: connected metal hard disk icons isolated on white background&quot;,&quot;created_timestamp&quot;:&quot;1340494952&quot;,&quot;copyright&quot;:&quot;Oleksiy Mark - Fotolia&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;Database and networking concept&quot;,&quot;orientation&quot;:&quot;1&quot;}\" data-image-title=\"Database and networking concept\" data-image-description=\"\" data-image-caption=\"&lt;p&gt;Database and networking concept: connected metal hard disk icons isolated on white background&lt;\/p&gt;\n\" data-large-file=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2017\/04\/databases.jpg?fit=660%2C409&amp;ssl=1\" class=\"aligncenter wp-image-27484 size-medium\" src=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2017\/04\/databases-500x310.jpg?resize=500%2C310&#038;ssl=1\" width=\"500\" height=\"310\" srcset=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2017\/04\/databases.jpg?resize=500%2C310&amp;ssl=1 500w, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2017\/04\/databases.jpg?resize=768%2C476&amp;ssl=1 768w, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2017\/04\/databases.jpg?w=775&amp;ssl=1 775w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.sitepoint.com\/\">SitePoint<\/a> runs through a few options that one can use to <a href=\"https:\/\/www.sitepoint.com\/synchronize-wordpress-live-development-databases\/\">synchronize WordPress live and development databases<\/a>. \u00a0I&#8217;ve linked to \u00a0some of these options before, but it&#8217;s nice to have them all conveniently together. \u00a0The solutions discussed include WordPress-specific tools:<\/p>\n<ul>\n<li><a href=\"https:\/\/deliciousbrains.com\/wp-migrate-db-pro\/\">WP Migrate DB Pro<\/a><\/li>\n<li><a href=\"http:\/\/wp-sync-db.github.io\/\">WP Sync DB<\/a><\/li>\n<li><a href=\"https:\/\/wordpress.org\/plugins\/wpsitesynccontent\/\">WPSiteSync for Content<\/a><\/li>\n<li><a href=\"https:\/\/wordpress.org\/plugins\/database-sync\/\">Database Sync<\/a><\/li>\n<li><a href=\"https:\/\/wordpress.org\/plugins\/wordpress-importer\/\">WordPress Importer<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/jplew\/SyncDB\">SyncDB<\/a><\/li>\n<li><a href=\"https:\/\/wordpress.org\/plugins\/wp-staging\/\">WP Staging<\/a><\/li>\n<li><a href=\"https:\/\/wordpress.org\/plugins\/wp-github-sync\/\">WordPress GitHub Sync<\/a><\/li>\n<li><a href=\"https:\/\/wordpress.org\/plugins\/pushlive\/\">PushLive<\/a><\/li>\n<li><a href=\"https:\/\/wpstagecoach.com\/\">WP Stagecoach<\/a><\/li>\n<\/ul>\n<p>as well as generic tools, such mysqldump, mysqlpump, rsync, and git.<\/p>\n<p>Overall, it&#8217;s a pretty complete list of tools. \u00a0The one I&#8217;d like to add though is <a href=\"http:\/\/wp-cli.org\/\">WP CLI<\/a>, which allows a great deal of automation when it comes to WordPress, including things like database imports and exports, post and option management, and more.<\/p>\n<p>&nbsp;<\/p>\n<!-- google_ad_section_end -->\n","protected":false},"excerpt":{"rendered":"<!-- google_ad_section_start -->\n<p>SitePoint runs through a few options that one can use to synchronize WordPress live and development databases. \u00a0I&#8217;ve linked to \u00a0some of these options before, but it&#8217;s nice to have them all conveniently together. \u00a0The solutions discussed include WordPress-specific tools: WP Migrate DB Pro WP Sync DB WPSiteSync for Content Database Sync WordPress Importer SyncDB &hellip; <a href=\"https:\/\/mamchenkov.net\/wordpress\/2017\/04\/04\/how-to-synchronize-wordpress-live-and-development-databases\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">How to Synchronize WordPress Live and Development Databases<\/span><\/a><\/p>\n<!-- google_ad_section_end -->\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"How to Synchronize WordPress Live and Development Databases #WordPress #WebDev #SysAdmin #DevOps #databases #deployment","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_links_to":"","_links_to_target":""},"categories":[1,6,18,133,62,1334,60],"tags":[1559,1586,3066,38,1330],"keyring_services":[],"class_list":["post-27483","post","type-post","status-publish","format-standard","hentry","category-general","category-linux","category-programming","category-sysadmin","category-technology","category-web-work","category-wordpress","tag-databases","tag-deployment","tag-mysql","tag-php","tag-web-development"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":28624,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/06\/11\/forget-db-a-simple-gdpr-inspired-tool-to-anonymise-confidential-database-data\/","url_meta":{"origin":27483,"position":0},"title":"forget-db &#8211; a simple GDPR inspired tool to anonymise confidential database data","author":"Leonid Mamchenkov","date":"June 11, 2018","format":false,"excerpt":"forget-db: A simple(ish) command line tool written in PHP 7.1 using Laravel Zero and Faker to help you anonymise\/pseudonymise data within your database to support protecting either sensitive information, or peoples right to be forgotten with GDPR compliance. The tool allows you to connect to either mysql, postgres, sqlite or\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":25946,"url":"https:\/\/mamchenkov.net\/wordpress\/2016\/03\/16\/aws-database-migration-service\/","url_meta":{"origin":27483,"position":1},"title":"AWS Database Migration Service","author":"Leonid Mamchenkov","date":"March 16, 2016","format":false,"excerpt":"AWS Database Migration Service is yet another one of those tools that you always wished that somebody created, but never actually got to checking if it exists. \u00a0Here is a recent blog post showcasing the functionality. Do you currently store relational data in an on-premises Oracle, SQL Server, MySQL, MariaDB,\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"AWS Database Migration Service","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2016\/03\/dms_connect_endpoints_filled_3-500x409.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":28287,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/12\/20\/mysql-optimize-repair-and-analyze\/","url_meta":{"origin":27483,"position":2},"title":"MySQL optimize, repair, and analyze","author":"Leonid Mamchenkov","date":"December 20, 2017","format":false,"excerpt":"Years ago I had the following script running as a cron job, but then I lost it somewhere.\u00a0 It took me a few minutes to find it again, but just in case I need it in the future, I'm saving it here. Found it here this time.","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":25965,"url":"https:\/\/mamchenkov.net\/wordpress\/2016\/03\/23\/good-bye-google-chrome-hello-chromium\/","url_meta":{"origin":27483,"position":3},"title":"Good bye Google Chrome, hello Chromium","author":"Leonid Mamchenkov","date":"March 23, 2016","format":false,"excerpt":"Google dropped the support of its Google Chrome browser on 32-bit Linux operating systems. \u00a0This is very unfortunate, but not deadly. \u00a0This change doesn't affect the Chromium browser - the Open Source project behind Google Chrome. The two are very compatible. \u00a0In fact, if you use the Google Sync in\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"Chromium-vs-Google-Chrome","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2016\/03\/Chromium-vs-Google-Chrome-500x247.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":29062,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/12\/10\/mysql-high-availability-at-github\/","url_meta":{"origin":27483,"position":4},"title":"MySQL High Availability at GitHub","author":"Leonid Mamchenkov","date":"December 10, 2018","format":false,"excerpt":"Shlomi Noach, GitHub's Senior Infrastructure Engineer, shares some details on both the current and future high availability setup of MySQL databases at GitHub. This is probably way too far out for most people using MySQL for their web applications.\u00a0 But it does highlight the technical complexity of running high load\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/12\/mysql-ha-solution-at-github.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/12\/mysql-ha-solution-at-github.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/12\/mysql-ha-solution-at-github.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/12\/mysql-ha-solution-at-github.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/12\/mysql-ha-solution-at-github.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/12\/mysql-ha-solution-at-github.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":22436,"url":"https:\/\/mamchenkov.net\/wordpress\/2014\/08\/26\/stellar-fast-database-snapshot-and-restore-tool-for-development\/","url_meta":{"origin":27483,"position":5},"title":"Stellar &#8211; fast database snapshot and restore tool for development","author":"Leonid Mamchenkov","date":"August 26, 2014","format":"link","excerpt":"Stellar - Fast database snapshot and restore tool for development.","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"stellar","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2014\/08\/stellar-500x333.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/27483","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/comments?post=27483"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/27483\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=27483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=27483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=27483"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=27483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}