Drupal site shows frontpage instead of added content
You might have all of the tables, but you might not have all of the rows, perhaps. Two tables to look at: node and node_revision. See of there are rows there.