word-press url change, site not loading correctly

If you wordpress url has changed, while accessing the domain. Your site will not load correctly.
For this you need to change the values in the wordpress database.

First you need to change the siteurl field inthe wp_otions table,

select * from wp_option where option_name="siteurl";

update wp_options SET option_value="http://newdomainname.com" where option_name="siteurl"

Then you need to update the "home" field in the wp_otions table,
select * from wp_options where option_name="home";
update wp_options SET option_value="http://newdomainname.com" where option_name="home";