I have shifted my magento 1.9 installation from
<domain>. Front page of my magento loads fine, but none of the link thereafter does not work whatsoever. All of them throws 404 error. All the category pages, products page, admin page, CMS pages throws 404 error.
I followed database approach from link http://www.inmotionhosting.com/support/website/magento/how-to-change-url
To add more info, I have updated table
core_config_data, rows with path 'web/unsecure/base_url' and 'web/secure/base_url'. After that, I have cleaned cache, but to no avail.
Then, I tried changing admin url by editing
app/var/local.xml, but that also didn't work.