Error in restoring data from live site to local instance

I am trying to create a local instance of a live site which is using v-14 ERPnext. When i run bench restore. I get the following error:

‘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’

I have re-downloaded the backup file, tried using force, even created a whole new bench and installed the required app, but I still have the same issue

Any idea what is wrong?