when you say “contents”, are you referring to the “wp-contents” directory or are referring to your actual post content? If it is the database .sql file you are meaning, http://www.tamba2.org.uk/wordpress/restore/ might prove to be a useful tutorial. If you need more general info about PHPmyadmin, http://www.tamba2.org.uk/wordpress/phpmyadmin2/ will shed some light.
If not the database, then clarify and well get you in the right direction.
Try taking a look at this page on restoring your DB in the codex.
What Miklb is saying is right; WP stores the blog posts in the DB so to backup your data, you’ll also need to have backed up your DB first. You can then follow the link we’ve posted which will guide you on your way to restoring the posts.
Backing up your wp-content folder only backs up your plugins, uploaded images and your themes (the design). To restore these, just reupload again.
hmmm… I’ve tried the steps in http://www.tamba2.org.uk/wordpress/restore/#two. But it doesn’t really work.
I want to move all the contents (not the wp-contents but the posts, comments, links etc) to a new directory (from niceric.com/blog to weblog.niceric.com).
It works fine, all the contents are there but when I click on any links, it actually link back to the previous directory, same happen when I trying to access admin panel, it actually access to old one.
hmmmm, did I miss something here?
You need to read up on moving WP now. Either http://codex.wordpress.org/Moving_WordPress or http://www.tamba2.org.uk/wordpress/site-url/
I’d start with the codex article, and if you run into a problems, then look at Podz’s tutorial.
And as always, run into problems, check back here.