I developed a site locally with /%postname%/
permalink structure. I did some sample posts locally and wanted to move this entire local setup to a temporary subdomain like http://review.clientsite.com.
1.) I exported the local sql table and imported it on the real database
2.) I changed the two fields inside the wp-options
table to fit the new url http://review.clientside.com
3.) I uploaded all files to the real server and got rid of the "wp-config.php" and installed wordpress on the real server.
4.) If I launch http://review.clientside.com I see the site running and everything seems to work just fine. The stylesheets, the js, everything.
However only thing that does not work are my permalinks! Every link ends in a 404 -> e.g. http://review.clientside.com/projects
I also copied the .htaccess file from my local server to the real one. I even tried dropping the entire "permalinks" field in the wp-options table and reset the permalink-structure in the permalink settings inside wp.
Any ideas on that matter?