Restore of database doesn’t show content

Check that you are actually using the database by doing the following:

1 – go to cpanel, file manager, public_html, open the wp_config.php file

2 – check db creds and make sure it is actually the correct db. Everything must be exact. (IP/localhost, dbname, user, etc.)

3 – check the $table_prefix – make sure the value matches the table that holds the post/pages. (WordPress uses $table_prefix so you can actually have multiple wordpress installs in the same database.)
E.g. $table_prefix = ‘wp_’; but your actual table name for posts is site_posts – then that’s the problem, they are different sites. If your actual table name is wp_posts – then it is OK.

4 – check your users table. Does the users match what you see in admin panel? If not, the website is not stored in that database.

Let’s say the prefix or any of the creds is wrong – just fix it directly in wp_config.php by editing the value to match. It should work right away.