I’m having this problem as well.
Oddly, I have 2 installations of WP on the same host server (different DB, obviously), only one is returning a 404 when I try to export. BOTH installations are using less than 4mb for DB content, so changing the memory limit is pointless in this case.
Other than the content, both installations are identical, so why would one export/generate correctly and not the other?
I’ve been trying to use a query like this to display 5 posts on front page and then my paged posts to display 10 (as set in the settings panel) .. is there any way to modify the query above to accomplish this?
Ta,
CK