Error while restoring the Data

We have taken the backup of the site and want to restore on local server to keep the backup of the backdated year.

But wile doing so, we are getting the following error.

Table `tabDefaultValue` not found in file.
Table 'tabDefaultValue' missing in the restored site. Database not installed correctly, this can due to lack of permission, or that the database name exists. Check your mysql root password, validity of the backup file or use --force to reinstall

What could be the issue?

Could be one of the following issues:

  • default max_allowed_packet setting for mysqldump not overridden in /etc/mysql/my.cnf (frappe recommends 256MB on most setups)
  • backup incomplete due to failure on server side. may be missing tabDefaultValue