Why are no posts showing despite my apparently correct DB restoration?

Check all credentials in wp-config.php. And don’t forget about table prefix.