Title: Restore Problem
Last modified: September 7, 2020

---

# Restore Problem

 *  Resolved [marcomelillo1293](https://wordpress.org/support/users/marcomelillo1293/)
 * (@marcomelillo1293)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/restore-problem-5/)
 * I try to restore a package created with the plugin but the db gives me the same
   error on all folders.
 * this:
 * [sql=/*!40000 ALTER TABLE `3ly_wfhits` ENABLE KEYS */;…]
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Frestore-problem-5%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/restore-problem-5/#post-13372831)
 * Hey [@marcomelillo1293](https://wordpress.org/support/users/marcomelillo1293/),
 * To work-a-round these issues you have a few options:
 * **1. Build in PHP Mode:** To avoid any directives that mysqldump generates you
   can change the build mode to PHP which uses the minimal amount of mysql/mariadb
   directives. Simply goto Settings ❯ Packages Tab ❯ SQL Script ❯ “PHP Code”. Then
   rebuild the package and re-install.
 * **2. Modify SQL Script (Advanced):** In a web browser browse to the installer.
   php. Then check the file system (via FTP, cPanel, Explorer etc.) a directory 
   named “dup-installer” should be present. Open the database.sql file found inside
   the dup-installer directory and modify this file so that the directives support
   the new mysql/mariadb server your on. To do this typically you can remove settings
   that look like the code block below. Typically its best to only remove the line
   where you are seeing the errors.
 *     ```
       ...
       /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
       /*!40101 SET @saved_cs_client = @@character_set_client */;
       /*!40101 SET character_set_client = utf8 */;
       ```
   
 * So in the event, the installer reported an error such as:
 * `'Variable 'character_set_client' can't be set to the value of 'NULL'' - [sql
   =/*!40101 SET character_set_client = @saved_cs_client */;...]`
 * Then you might simply try to remove the last line, save the dup-database_[hash].
   sql file and run the installer again. If the issue persists check the errors 
   till the version of msyql/marida is satisfied with the directives set. If the
   database engine versions are too far apart then we would recommend working with
   your host or server admin to bring the version closer together.
 * Let me know if that helps~

Viewing 1 replies (of 1 total)

The topic ‘Restore 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/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [keys](https://wordpress.org/support/topic-tag/keys/)
 * [lock](https://wordpress.org/support/topic-tag/lock/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [tables](https://wordpress.org/support/topic-tag/tables/)

 * 1 reply
 * 2 participants
 * Last reply from: [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/restore-problem-5/#post-13372831)
 * Status: resolved