Restore Problem

  • Resolved marcomelillo1293

    (@marcomelillo1293)


    4 years, 2 months ago

    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 to see the link]

Viewing 1 replies (of 1 total)

  • Hey @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.