Title: db.dmp to database.sql problem
Last modified: August 22, 2016

---

# db.dmp to database.sql problem

 *  Resolved [brianmurphy](https://wordpress.org/support/users/brianmurphy/)
 * (@brianmurphy)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/dbdmp-to-databasesql-problem/)
 * I’ve experienced this with WP 3.8.3 and 3.9.2. I have the latest 0.5.6 Duplicator
   plugin. The client’s webhosting company is using plesk.
 * They have many wordpress installations done in subdirectories:
 * /httpdocs/(main wp)
    /httpdocs/subdir1/(wp) /httpdocs/subdir2/(wp) etc.
 * 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.
 * 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.
 * 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.
 * If I have time, I will try looking through the plugin source code.
 * Thank you for your attention,
    Brian
 * [https://wordpress.org/plugins/duplicator/](https://wordpress.org/plugins/duplicator/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/dbdmp-to-databasesql-problem/#post-5191817)
 * Hey Brian,
 * That is quite odd, don’t think I have had anyone report that exact issue… If 
   you find something out of sync definitely let me know. The code is also on [github](https://github.com/lifeinthegrid/duplicator).
 * Cheers~
 *  [Phenar](https://wordpress.org/support/users/phenar/)
 * (@phenar)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/dbdmp-to-databasesql-problem/#post-5192088)
 * Hi,
 * I have some similar problem here. (Using WP 4.0.1 and Duplicator 0.5.8)
 * By creating an archive locally, the database.sql in the *_archive.zip is an old
   version. It has the same state when the database was being installed. The separately
   created database.sql (not included to the zip) does show the current state with
   all changes.
 * I have to say, that the installation process on this local machine was done with
   files from another local database (same settings and the site is not live yet)
   by extracting the *_archive.zip to ..\xampp\htdocs\wordpress without database.
   sql. The database.sql was imported via phpmyadmin directly. (And not via installer.
   php)
 * How can I fix this issue so that the actual database.sql will be copied into 
   the *_archive.zip?
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/dbdmp-to-databasesql-problem/#post-5192089)
 * Hey Phenar,
 * Currently the only way to have the most recent copy of the database.sql file 
   added to the archive.zip file is to create a new package and then download it.
 * Cheers~
 *  [Phenar](https://wordpress.org/support/users/phenar/)
 * (@phenar)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/dbdmp-to-databasesql-problem/#post-5192090)
 * Hi Cory,
 * Meanwhile:
    – I copied the separately created database.sql into the archive.zip,–
   uploaded and installed on the host server, – deleted the local database completely,–
   downloaded the backup from host, – and installed locally again.
 * No synch problems anymore as before. Thanks, anyway. 🙂
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/dbdmp-to-databasesql-problem/#post-5192091)
 * Sounds Good! Thxs for the update.

Viewing 5 replies - 1 through 5 (of 5 total)

 The topic ‘db.dmp to database.sql problem’ is closed to new replies.

 * ![](https://ps.w.org/duplicator/assets/icon-256x256.png?rev=2906985)
 * [Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More](https://wordpress.org/plugins/duplicator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/duplicator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/duplicator/)
 * [Active Topics](https://wordpress.org/support/plugin/duplicator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/duplicator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/duplicator/reviews/)

 * 5 replies
 * 3 participants
 * Last reply from: [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * Last activity: [11 years, 10 months ago](https://wordpress.org/support/topic/dbdmp-to-databasesql-problem/#post-5192091)
 * Status: resolved