Problem in Restoring Database

  • Resolved SolutionsDEV

    (@solutionsdev)


    2 years, 6 months ago

    This is a wonderful plugin. I backed up the database to gdrive and it worked smoothly, I downloaded the database locally and tried to re-build the database after removing tables from the backup, but for every SQL query it gave an error and could not create any table.

    Any solution to this?

    Thanks,

Viewing 10 replies - 1 through 10 (of 10 total)
  • Thread Starter SolutionsDEV

    (@solutionsdev)

    2 years, 6 months ago

    This is an example of the database errors when trying to restore in phpmyadmin:

    Static analysis:

    896 errors were found during analysis.

    1. Unexpected character. (near “” at position 11)
    2. Unexpected character. (near “” at position 12)
    3. Unexpected character. (near “” at position 13)
    4. Unexpected character. (near “” at position 14)
    5. Unexpected character. (near “” at position 15)
    Plugin Contributor Backuply

    (@backuply)

    2 years, 6 months ago

    Hello @solutionsdev ,

    Would you please tell, if you have manually removed the tables through some text editor?

    Regards,
    Backuply Team

    Thread Starter SolutionsDEV

    (@solutionsdev)

    2 years, 6 months ago

    Hello @backuply,

    When the tables are removed, they are removed manually in phpmyadmin. I have tried many times, sometimes after removing the tables and some others without removing tables, all lead to the same errors.

    When tried to import tables that were backed up not using backuply, they worked fine. For this my suspension is that the SQL written by backuply is not completely compatible with MySQL queries.

    Thanks,

    Plugin Contributor Backuply

    (@backuply)

    2 years, 6 months ago

    Hello,

    We are sorry for the inconvinence caused. Would you please tell us which SQL version are you using so we can try to replicate the issue?

    Regards,
    Backuply Team

    Thread Starter SolutionsDEV

    (@solutionsdev)

    2 years, 6 months ago

    Hello @backuply,

    It is MySQL 10.6.14-MariaDB-cll-lve.

    Regards,

    Plugin Contributor Backuply

    (@backuply)

    2 years, 6 months ago

    Hello @solutionsdev ,

    Thanks for the information, I tried to recreate the issue you are facing on our end, but it worked without any issue for us.
    Will it be possible for you to contact us on https://softaculous.deskuss.com/open.php?topicId=17
    So we can look at the issue, and see if there is any issue in the SQL file.

    Regards,
    Backuply Team

    Plugin Contributor Backuply

    (@backuply)

    2 years, 5 months ago

    Hello @solutionsdev ,

    Would you please tell us if you were able to fix the issue you were facing, or if you have any updates regarding this issue?

    Regards,
    Backuply Team

    Thread Starter SolutionsDEV

    (@solutionsdev)

    2 years ago

    Hello @backuply,

    Thanks for your support.

    I do not know what has changed, but I have retested the plugin lately and switched off all selections and the result was successful, so, yes, I can confirm now that the compatibility is working fine; I am taking about the import of the database manually.

    I also have tested the restore feature of Backuply plugin and it working perfectly as it should, one little thing is that it needed to synch with gDrive after restoring.

    So, the conclusion is that this plugin, Backuply, if well done and recommended.

    Thanks again for the good support

    Plugin Contributor Backuply

    (@backuply)

    2 years ago

    Hello,

    Thanks for updating us about the plugin working fine for you now. Do let us know if you face any other issues.

    Regards,
    Backuply Team

    Thread Starter SolutionsDEV

    (@solutionsdev)

    2 years ago

    Thank you.

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

The topic ‘Problem in Restoring Database’ is closed to new replies.