Title: Problem in Restoring Database Last modified: August 8, 2023 --- # Problem in Restoring Database * Resolved [SolutionsDEV](https://wordpress.org/support/users/solutionsdev/) * (@solutionsdev) * [3 years, 1 month ago](https://wordpress.org/support/topic/problem-in-restoring-database/) * 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](https://wordpress.org/support/users/solutionsdev/) * (@solutionsdev) * [3 years, 1 month ago](https://wordpress.org/support/topic/problem-in-restoring-database/#post-16955464) * 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](https://wordpress.org/support/users/backuply/) * (@backuply) * [3 years, 1 month ago](https://wordpress.org/support/topic/problem-in-restoring-database/#post-16955838) * Hello [@solutionsdev](https://wordpress.org/support/users/solutionsdev/) , * Would you please tell, if you have manually removed the tables through some text editor? * Regards, Backuply Team * Thread Starter [SolutionsDEV](https://wordpress.org/support/users/solutionsdev/) * (@solutionsdev) * [3 years, 1 month ago](https://wordpress.org/support/topic/problem-in-restoring-database/#post-16956090) * Hello [@backuply](https://wordpress.org/support/users/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](https://wordpress.org/support/users/backuply/) * (@backuply) * [3 years, 1 month ago](https://wordpress.org/support/topic/problem-in-restoring-database/#post-16956105) * 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](https://wordpress.org/support/users/solutionsdev/) * (@solutionsdev) * [3 years, 1 month ago](https://wordpress.org/support/topic/problem-in-restoring-database/#post-16956172) * Hello [@backuply](https://wordpress.org/support/users/backuply/), * It is MySQL 10.6.14-MariaDB-cll-lve. * Regards, * Plugin Contributor [Backuply](https://wordpress.org/support/users/backuply/) * (@backuply) * [3 years, 1 month ago](https://wordpress.org/support/topic/problem-in-restoring-database/#post-16956234) * Hello [@solutionsdev](https://wordpress.org/support/users/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](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](https://wordpress.org/support/users/backuply/) * (@backuply) * [3 years, 1 month ago](https://wordpress.org/support/topic/problem-in-restoring-database/#post-17006241) * Hello [@solutionsdev](https://wordpress.org/support/users/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](https://wordpress.org/support/users/solutionsdev/) * (@solutionsdev) * [2 years, 8 months ago](https://wordpress.org/support/topic/problem-in-restoring-database/#post-17369159) * Hello [@backuply](https://wordpress.org/support/users/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](https://wordpress.org/support/users/backuply/) * (@backuply) * [2 years, 8 months ago](https://wordpress.org/support/topic/problem-in-restoring-database/#post-17381415) * 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](https://wordpress.org/support/users/solutionsdev/) * (@solutionsdev) * [2 years, 8 months ago](https://wordpress.org/support/topic/problem-in-restoring-database/#post-17382344) * Thank you. Viewing 10 replies - 1 through 10 (of 10 total) The topic ‘Problem in Restoring Database’ is closed to new replies. * ![](https://ps.w.org/backuply/assets/icon-128x128.png?rev=2760139) * [Backuply - Backup, Restore, Migrate and Clone](https://wordpress.org/plugins/backuply/) * [Frequently Asked Questions](https://wordpress.org/plugins/backuply/#faq) * [Support Threads](https://wordpress.org/support/plugin/backuply/) * [Active Topics](https://wordpress.org/support/plugin/backuply/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/backuply/unresolved/) * [Reviews](https://wordpress.org/support/plugin/backuply/reviews/) * 10 replies * 2 participants * Last reply from: [SolutionsDEV](https://wordpress.org/support/users/solutionsdev/) * Last activity: [2 years, 8 months ago](https://wordpress.org/support/topic/problem-in-restoring-database/#post-17382344) * Status: resolved