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.

DO NOT change the guids. Those are NOT permalinks and are meant to be static once created.
–
EAMann♦Aug 14 '12 at 17:20

1

I've used those queries for innumerable domain and localhost to domain moves and they work fine. The queries do not change the whole GUID, only the domain part of the GUID.
–
markratledgeAug 14 '12 at 17:24

I'm not saying they won't work, I'm saying you shouldn't be changing the GUID at all even when you're moving domains.
–
EAMann♦Aug 14 '12 at 18:51

Thank you. But it seems the problem is somewhere else on the server. I did a clean install of wordpress on the subdomain and again – no page or post i create works - always a 404.
–
mathiregisterAug 14 '12 at 20:32

Looks like a server config problem; talk to the host administrator. Is mod_rewrite enabled on server? There's a placeholder page at the main domain. But the subdomain review.clientside.com doesn't even resolve for me; it is on a LAN or accessable from the internet?
–
markratledgeAug 14 '12 at 20:49