How to backup my wordpress database and view using my computer's WAMP?

Hi, I have installed WAMP and installed a new fresh wordpress on my PC. I have a wordpress blog on my webhosting that I would like to download and install at my pc. Is there any certain guide? I know that I should import my sql data from my webhosting and also download the blog files and place it at my WAMP subfolder.
However when I uploaded the sql database to my newly fresh installed wordpress at my when I tried opening it it only came out a blank white page.
Is there any certain guide on this? Would be appreciated some help. Thanks

 

http://wordpress.org/extend/plugins/wp-db-backup/

 

I already know how to backup just how to setup n view it at my pc.

 

You might try using the tools-import sometimes just moving the sql files to a local host can keep the wrong address in the files.

 

Well I am using to import the sql database from import ay phpmyadmin but does not seems to work on my PC.

 

Try the import tool in WP in the dashboard, it will rewrite some of the address in the database info.

 

where do I get the xml?

 

backup sql but without table "wp-options"
its work for me....
because wp-option contain web url setting....

 

What I think might be happening (not sure just a guess) is the info in your database still has your web url, sometimes that will make it come up as a blank screen.

WP import tool will rewrite this or you can do it manually.

Try checking your SQL database

- Wp_options - (open this) – the 2nd item down should be - "site url" - this should be "http://localhost/yoursitename"

Not sure if this is what the trouble is but it is worth checking out.

 

K. thanks everyone. Will try again. rep added to all replied here.
Cheerio

 

export the database from wordpress
then open php my admin and import it

 

what do you mean with the above BOLD