database migration of wordpress


masaharu

Recommended Posts

Database migration from xampp localhost to shared host didn't go well.

Images are displayed, I can login, URL of posts are correct, top page is displayed but other pages are 404.

Theme is customizr and i use child theme.

Setting of customizr is also lost.

 

Allow me explain what i did.

 

 

 

  1. Upload new wordpress files to public_html folder
  2. upload theme, plugin, upload to wordpress folder in public_html folder
  3. Export sql file from local phpmyadmin
  4. I saved screenshot of export options in my google drive
    https://drive.google.com/file/d/0B1l4Jo3Y_WwJdXhFVmYwcENXUU0/view?usp=sharing
  5. Open SQL file with notepad++
  6. replace all  http://localhost/promoteyourappinjapan to http://lokalizer.biz
  7. replace promoteyourappinjapan to lokalizer.biz

 

I didn't change wp-config.php

 

I doubt that I should keep localhost as it is in some case because host name is localhost

 

Thanks,

Link to comment
Share on other sites

Hello TOny,

Thank you very much for response.
I've uploaded it to public_html directory.

 

The content is below but nothing changed.

I can access to wp-admin so problem might not be url.

 

 
# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /http://lokalizer.biz/ [L]
</IfModule>
 
# END WordPress
Link to comment
Share on other sites

Hello,

 

Your .htaccess code seems to be incorrect.  You'll probably want the default mod_rewrite rules:

# 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
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...