Seems like the restoration fails during search & replace step.
Reason of that is insufficient memory for that process.
Fortunately, we have released new beta version which includes huge improvements for that area in our plugins.
It adds batching method to the search & replace step, which basically allows you to bypass time and memory limits.
There is no need for you to make new backup, you can simply update the plugin and run restoration once again. It’s compatible with older backups.
But in your case, I’d recommend to make new backup if you can but before you do that perform full cleanup and optimize all your tables (you can use this plugin for that: https://wordpress.org/plugins/advanced-database-cleaner).
Basing on sizes of your database, it’s very likely that it contain a lot of junk data, that you don’t really want to have. Clean-up should also make your site load quicker.
Let me know if that resolves your issue or you need more details 🙂
Great, thank you for confirmation! 🙂