Developers India 2019

This is very often situation where you need to transfer WordPress from one server to another server. Below are steps, by which this thing can be done most easily.

 

  1. Transfer all files to other server where you will need to setup WordPress.
  2. Go to wp-content/wp-config.php , set database name, username, password and host name.
  3. Open the database, go to wp_options table , set  site_url value and home .. both this option will have value will have new server home url. In case if you want to setup it for local server then give url address for local server http://localhost/abc . site_url has option_id value is 1 and home has option_id value is 37 if you would like to locate them quickly.
  4. Now next thing, if already website has posts or pages.. then we may need to change its url. We are not going to entertain this thing by one by one record instead of we will fire query to make life easier. We need to change value guid in wp_post table… suppose older server address is abc. com and new server is xyz.com then below query will replace all value of url of abc.com to xyz.com. You can repeat below process for post_content field in wp_post as per your need.
  5.  So by this way we have converted all older server’s url by new one.
     Lastly check .htaccess file at root folder. Add folder location as per your need  Suppose my website at local server. It location is in abc folder then .htaccess code   will look like as below
    <IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /abc/
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /abc/index.php [L]
</IfModule>
    If website at root folder then code no need to put folder location in RewriteBase and Rewrite Rule. Code will look like
    <IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ./index.php [L]
</IfModule>
    Note : Please ignore .htaccess related change if you don’t want Permalink in custom structure folder. If Permalink is set with default option, then  .htaccess related changes not required.
    That’s all . You done.

Related Posts: