I have moved to new host. After restoring sql with phpmyadmin it looks like my blog is restored but only the front page is working. When clicking on a post or a menu item or just moving to "older posts" I get
The requested URL /blog2/2009/11/23/christmas-card-contest/ was not found on this server.
When I go to Admin, Posts, I can see all the posts. Apparently everything has been restored but the links from front page to posts and pages are not being recognized.
When I hover over a post heading and see the link information in the status bar at bottom of browser, it is the same as shown in Edit Posts.