{"id":18742,"date":"2012-11-13T18:10:35","date_gmt":"2012-11-13T18:10:35","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/database-sync\/"},"modified":"2015-08-26T19:44:12","modified_gmt":"2015-08-26T19:44:12","slug":"database-sync","status":"closed","type":"plugin","link":"https:\/\/wordpress.org\/plugins\/database-sync\/","author":191764,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"0.5.1","stable_tag":"0.5.1","tested":"4.0.38","requires":"3.0","requires_php":"","requires_plugins":"","header_name":"Database Sync","header_author":"tamlyn","header_description":"","assets_banners_color":"","last_updated":"2015-08-26 19:44:12","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"","header_author_uri":"","rating":4.6,"author_block_rating":0,"active_installs":300,"downloads":26437,"num_ratings":23,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","changelog"],"tags":[],"upgrade_notice":[],"ratings":{"1":"1","2":"1","3":"1","4":0,"5":"21"},"assets_icons":[],"assets_banners":[],"assets_blueprints":{},"all_blocks":[],"tagged_versions":["0.2","0.3","0.3.1","0.4","0.5","0.5.1"],"block_files":[],"assets_screenshots":[],"screenshots":[]},"plugin_section":[],"plugin_tags":[2738,153,10609,1558,22764],"plugin_category":[59],"plugin_contributors":[79964],"plugin_business_model":[],"class_list":["post-18742","plugin","type-plugin","status-closed","hentry","plugin_tags-copy","plugin_tags-database","plugin_tags-db","plugin_tags-sync","plugin_tags-synch","plugin_category-utilities-and-tools","plugin_contributors-tamlyn","plugin_committers-tamlyn"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/database-sync.svg","icon_2x":false,"generated":true},"screenshots":[],"raw_content":"<!--section=description-->\n<p><strong>WARNING:<\/strong> This plugin is for advanced users. If used incorrectly it could wipe out <em>all your content<\/em>!<\/p>\n\n<p>Keeping databases in sync between development, staging and live servers can be a pain. This plugin lets you\nlink together several WordPress installations by sharing a secret token. Once linked, administrators can pull\nor push the entire database between servers with just a click.<\/p>\n\n<p>Currently syncs database only, not uploaded files.<\/p>\n\n<h4>Backups<\/h4>\n\n<p>The plugin will attempt to make local backups of the database before overwriting. These are stored as gzipped SQL\nfiles in wp-content\/plugins\/database-sync\/backups\/dbYYYYMMDD.HHMMSS.sql.gz The backups directory should be made\nwritable, and you should keep an eye on it if you sync often as it will grow in size.<\/p>\n\n<h4>Usage<\/h4>\n\n<p>See Installation instructions.<\/p>\n\n<p><a href=\"http:\/\/outlandish.com\">Plugin by Outlandish<\/a><\/p>\n\n<!--section=installation-->\n<ol>\n<li>Install as usual.<\/li>\n<li>Activate plugin.<\/li>\n<li>Repeat 1 &amp; 2 on each server that you want to link.<\/li>\n<li>Go to Tools &gt; Database Sync on the main server and copy the token.<\/li>\n<li>On the other server(s), go to Tools &gt; Database Sync and paste the token.<\/li>\n<\/ol>\n\n<p>You are now set up to pull from and push to the main server.<\/p>\n\n<!--section=changelog-->\n<h4>Version 0.5.1<\/h4>\n\n<ul>\n<li>Extra URL sanitisation.<\/li>\n<\/ul>\n\n<h4>Version 0.5<\/h4>\n\n<ul>\n<li>Fixed XSS vulnerability.<\/li>\n<\/ul>\n\n<h4>Version 0.4<\/h4>\n\n<ul>\n<li>Support for dumping and syncing MySQL VIEWs.<\/li>\n<\/ul>\n\n<h4>Version 0.3.1<\/h4>\n\n<ul>\n<li>Fixed E_NOTICE warning. Thanks to miniragnarok.<\/li>\n<\/ul>\n\n<h4>Version 0.3<\/h4>\n\n<ul>\n<li>Use <code>$wpdb<\/code> instead of deprecated <code>mysqli<\/code> extension. Thanks to Simon East.<\/li>\n<li>Fixed manual dump download filename. Thanks to Ronald Mansveld.<\/li>\n<\/ul>\n\n<h4>Version 0.2<\/h4>\n\n<ul>\n<li>Initial public release.<\/li>\n<\/ul>\n\n<h4>Version 0.1<\/h4>\n\n<ul>\n<li>Internal testing.<\/li>\n<\/ul>","raw_excerpt":"Sync databases across servers with a single click.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/18742","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=18742"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/tamlyn"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=18742"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=18742"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=18742"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=18742"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=18742"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=18742"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}