No create a separate fresh install of the website then copy some database files from the new fresh install to the website you transferred that are broken
What I did to fix it was created a seperate brand new installation of Xenforo and then copied the corrupt database files over to my old database and replaced them, the error went after that. @adamsmasher
I have re-installed the backup many times and I always end up with the error:
XF\Db\Exception: MySQL statement prepare error [1932]: Table 'edawgcom_xen.xf_template_phrase' doesn't exist in engine in src/XF/Db/AbstractStatement.php at line 212
XF\Db\AbstractStatement->getException()...
On phpmyadmin I find the xf_template_phrase and it's there, but when I click on it, it says "#1932 - Table 'edawgcom_website.xf_template_phrase' doesn't exist in engine"