First time connect to your WordPress blog via local network IP. No styles and no scripts are loaded. Why? Look at the code of the loaded page. All links to scripts and styles begins with ‘http://localhost/‘. Spot IP of your computer in the local network with the help of console comand ‘ifconfig’ (for Ubuntu). Open menu Settings – General in wordpress dashboard. Replace ‘http://localhost/‘ in the WordPress Address (URL) and Site Address (URL) with the detected IP – ‘http://192.168.11.187/‘ (192.168.11.187 – as an example). This action will eliminate problems with links to your scripts and styles.
The better way is here (from http://www.uamedwed.com/blog/web/perenos-sajta-na-drugoj-domen-i-xosting.html):
UPDATE _F9J_options SET option_value = replace(option_value, 'http://domain.com','http://newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE _F9J_posts SET guid = replace(guid, 'http://domain.com','http://newdomain.com'); UPDATE _F9J_posts SET post_content = replace(post_content, 'http://domain.com','http://newdomain.com');
I’ve added one more line:
UPDATE _F9J_postmeta SET meta_value = replace(meta_value, 'http://domain.com','http://newdomain.com') where meta_id>0;
condition “where meta_id>0” is added to avoid following error:
"Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Queries and reconnect."