All of my database connections are good
I’m seeing “Error establishing a database connection”.
That can’t be “good”.
Database tables that are missing :
A fresh WordPress installation has 12 database tables. And if 10 of these are listed as missing, I wouldn’t call that “a few”.
If you still have access to the old hosting account, the simplest way out of this would be to temporarily point your domain to the old host and use a WordPress migration plugin to do a seamless migration, rather than doing this manually.
If that’s not an option for you…
How did you migrate the database?
Use phpMyAdmin or whatever database management tool your NEW host provides to check the database: are the “missing” tables present in the database?
And do they have the same prefix as what’s configured in your wp-config.php file?
The database file are given from the previous web developer. Then I just import the database into the phpMyAdmin that were given by my new host. However the “missing” tables are not present in the database but the still have the same prefix.