Error Restoring Snapshot

Hi,

Sorry to hear that ??

Most likely it’s an issue with the snapshot table count not matching the number of tables it thinks it should contain. Either something went wrong when creating it and the process has been interrupted or some other issue came up. We perform various checks when you try to restore a snapshot in order to prevent a compromised snapshot from being restored.

If the data in the snapshot is important you could extract it (it’s just an archive) and import the SQL file inside into a temporary table and see if it contains the data you need then manually restore that data.

Thanks for the quick reply Alexandria.

Do you have any guide as to how I can extract the tables and manually restore it using SQL

thanks

No, as it really depends on what database tools you have available. If your host provides you with phpMyAdmin you can search for ‘how to restore SQL file in phpMyAdmin’ ??

Thanks for the reply, my host uses phpMyAdmin and I’ve contacted my webmaster to help restore the snapshot using phpMyAdmin but when I login to wordpress dashboard the restore file has not reflected.

What else needs to be done after restoring the snapshot manually?

Thanks

The tables in the snapshot files are prefixed with the snapshot ID and looks like {6_char_random_snapshot_prefix}_{table_prefix_for_your_site}_{original_table_name}

Before doing anything you should check all the tables in the snapshot to see if everything is correct. You should check that all the tables you expect are there, and that they contain all the data they should (posts, users, etc.). If the users table is corrupted for example you might loose access to your website. So make sure you download a copy of the old WordPress tables before removing them.

In order to finish fully restoring them you first need to delete you current WordPress tables then remove the {6_char_random_snapshot_prefix} from the snapshot tables you have imported.

Alternatively you can check to see what that prefix is and change your WordPress table prefix to the {6_char_random_snapshot_prefix}_{table_prefix_for_your_site} prefix so it uses those snapshot tabled instead of the normal tables. This would allow you to test if WordPress would work using those tables.