Restore backup with SQL syntax erros

  • Resolved marcelocopetti

    (@marcelocopetti)


    9 months, 1 week ago

    • I am have a backup file (.zip) created by wp-clone plugin for wordpress
      That is giving an database error when I restore it and this file is from nov 11 2023.
      Instead of that, the file from aug 06 2023 works fine!
      But I would like to restore the newest

    The error is:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘schema = “{\”blockGraphs\”:[]https://easycolor.com.br\”customGraphs\”:[]https://’ at line 1

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author iClyde

    (@iclyde)

    Hi @marcelocopetti

    Please try to restore the backup in sandbox environment at https://demo.tastewp.com/bmi (it will generate brand new WP site which you can use for that, there is 1 GB limit of storage, if you need more let me know what’s the generated site URL is, I’ll increase the space).

    Once you restore the backup successfully there, make new backup using our new refreshed plugin Backup Migration which will be installed with URL above, and try to use the same plugin to restore the backup on the site where you experienced SQL syntax error.

    Let me know if that resolves your issue ??
    Thank you!

    Plugin Support MixHa

    (@mixha)

    Hello @marcelocopetti ,

    We haven’t heard from you since, so I’ll assume that the issue is resolved and will close this support thread. If you face any new issues, please feel free to open a new thread.

    Kind regards

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Restore backup with SQL syntax erros’ is closed to new replies.