Oh...my god, help me please........wordpress problem

Recently i backup my database using plugin wp dbmanager from my wp blog http://www.A.com and import it on mysql database of my another wp site http://www.B.com. the database change theme, plugins, structure everthing even when i try to login - http://B.com/wp-login.php they redirect to http://A.com/wp-login.php.

now if i visit - http://B.com, i see eveything same as http://A.com, and when i click any post they redirect too - http://A.com post page.

 

Just change every http://A.com to http://B.com in the database tables.

 

good advice !

 

I already import the sql file to www.B.com, can you suggest how can i edit the file, or i have delete first www.B.com sql file and than reupload if yes, how we delete the sql file.

 

change it in your database

find wp_options table

search for option_name, home and site_url

 

ok now i understand

can anyone tell, will i edit the sql file, to import it to my another wordpress blog (suppose - www.B.com) and after uploading sql file the previous posts of www.B.com will live or the sql file upload over the previous post of www.B.com