{"id":5191571,"date":"2014-08-14T18:09:26","date_gmt":"2014-08-14T18:09:26","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/dbdmp-to-databasesql-problem\/"},"modified":"2016-08-22T00:29:20","modified_gmt":"2016-08-22T00:29:20","slug":"dbdmp-to-databasesql-problem","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/dbdmp-to-databasesql-problem\/","title":{"rendered":"db.dmp to database.sql problem"},"content":{"rendered":"<p>I&#8217;ve experienced this with WP 3.8.3 and 3.9.2.  I have the latest 0.5.6 Duplicator plugin.  The client&#8217;s webhosting company is using plesk.<\/p>\n<p>They have many wordpress installations done in subdirectories:<\/p>\n<p>\/httpdocs\/(main wp)<br \/>\n\/httpdocs\/subdir1\/(wp)<br \/>\n\/httpdocs\/subdir2\/(wp)<br \/>\netc.<\/p>\n<p>I used duplicator to move one of the subdir sites to a new account and was getting the wordpress You must update your database page and a site with broken theme options.<\/p>\n<p>After some debugging, it appears the database.sql in archive.zip is an 8 month old DB dump from a different WP installation.  But the db.dmp file is a correct current database export.  I suspect there is a problem when duplicator resaves db.dmp as database.sql.  The timestamped xxxxx_database.sql file in wp_snapshots is the correct current version of the database.<\/p>\n<p>As a workaround, I manually extracted archive.zip in the new account and rewrote database.sql with the wp-snapshots version.  Then when running install.php, I got the site to work.<\/p>\n<p>If I have time, I will try looking through the plugin source code.<\/p>\n<p>Thank you for your attention,<br \/>\nBrian<\/p>\n<p>https:\/\/wordpress.org\/plugins\/duplicator\/<\/p>\n","protected":false},"template":"","class_list":["post-5191571","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5191571","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5191571\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=5191571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}