localhost to virtual host – Getting page not found or blank page

I have created a site on my localhost laptop. Now came time uploading to host. I have a site say mysite.com. On the host I want to make sure everything is well before pointing the actual domain name there. So my site is say http://123.123.123.123/~usersite.

Now I have had problems getting this to show properly. I have done a bulk change of the ‘localhost’ to ‘123.123.123.123/~usersite’.

Problem is that after I do this, I navigate to http://123.123.123.123/~usersite, the site comes up blank as if the DB configuration is incorrect. However, if I change ‘home’ (which I think is what I pinpointed the problem to) in wp_options -> option_value to something completely off the wall like ‘asdf’, the site comes up with all correct structure and theme stuff, except the pages come up as ‘Page not Found’ and the url structurs of the links are ‘123.123.123.123/asdf/page.

This is very strange because as soon as I change option_name ‘home’ option_value back to proper name, the site goes blank when going to the page.

I have ran out of steam on this. Any suggestions.

.htaccess seems to be fine. I just have bare bones .htacctess going:

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>

Also, everything is properly in the root directory.