404 on pages after restore from .sql dump

[Enoch Root]

Hi,

I've tried taking a copy of my Wordpress site and restoring it to a new site using a .sql export/ import. This seemed to work fine for the homepage/ menus etc but when clicking to other pages I get 404. I can see all the pages in Wordpress. I've tried changing permalink structure. mod_rewrite is enabled. Wordpress can write to .htaccess file.

I can't find any further clues as to what might be going wrong.

[guido2004]

What do the links that give you a 404 look like?

[Enoch Root]

http://xxx.xxxx.xxx/clinical/

[guido2004]

I suppose xxx.xxxxx.xxx is the correct domain name.
What happens if you set permalink settings to default?

[Enoch Root]

Default works fine, nothing else does.
I'm kind of assuming that Wordpress is changing .htaccess because I get prompted to reload it in the text editor.

[Enoch Root]

Default works fine, nothing else does.
I'm kind of assuming that Wordpress is changing .htaccess because I get prompted to reload it in the text editor.
Actually I've just checked this by switching the permalink structure and reloading, and Wordpress is definitely altering .htacccess.

[guido2004]

Can you post the htaccess content?

[Enoch Root]

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

# END WordPress

[guido2004]

And this is the htaccess for what permalink setting?

[Enoch Root]

/%postname%/

I'm wondering if it's because my site is a virtual host in Apache - although having said that I have the original site set up on another server as virtual and it works fine.

[guido2004]

The htaccess looks ok. And I always expect it to change with every permalink setting, but it doesn't. The different permalink structures are handled internally by WP. I have no idea why it wouldn't work.

[Enoch Root]

I have now. I had omitted to change the AllowOverride directive in httpd.conf to AllowOverride All. It now works fine. Thanks for your time. I often find that just spelling out the different aspects of a problem to someone else helps one to focus..

[guido2004]

I often find that just spelling out the different aspects of a problem to someone else helps one to focus..

Absolutely

[mmoore5553]

Usually a restore from sql you have to just change to default and save and then put it back to what you had originally. Then it fixes. Then run velvet urls if you changed domains.

But glad you redid your httacess to fix it.