how to change permalink in database

After migrating a WordPress site to a new URL either to a live production or a testing development server, the new URL strings in the mysql database need to be changed and updated in the various mysql database tables.

This method just uses the whole mysql database rather than a WordPress export/import from within, and is best suited for a straight swap. So you would copy all the WordPress files/folders to the new destination, set the correct ownership to those files,  then do the database switcheroo.

WordPress Database Switcheroo

First, do a mysql database export of the old database on the old server, create a new blank database on the new server, import the old data either in phpmyadmin or mysql directly in the command line.

Make sure you have the new database selected, then run some sql updates and replacement commands on the tables notably, wp_options, wp_posts, wp_postmeta.

Use the code as below and swap in your old and new URLs, no trailing slashes. Also if necessary change the table prefix values where applicable (ie wp_ )

 

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

mysql-updates-wordpress

W3 Total Cache Settings for WordPress

Optimal W3 Total Cache Settings

Note : Please take a backup before to install or uninstall w3 total cache plugin .Cache plugin store the data in your browser whenever you do any changes with website clear the cache and check it .

1.The First one is Dashboard,Just Leave it and Move.

W3 Total Cache General Settings

  • General: Leave it as it is.
  • Page Cache: Enabled
  • Page Cache Method: Disk Enhance
  • Minify:Enable
  • Minify Mode: Manual
  • Minify Cache Method – Disk
  • HTML Minifier: Default
  • JS Minifier: Default
  • CSS Minifier: Default or CSS Tidy

 

(Minify settings can cause compatibility problem with some themes and plugins,You can disable minify(it does not have any huge impact on speed) )

  • Database Cache: Enabled
  • Database Cache Method: Disk
  • Object Cache: Enable
  • Object Cache Method: Disk
  • Browser Cache: Enable
  • CDN : Enable it if you are using,otherwise Leave it and Move on.
  • Enable varnish cache purging: Disable

Network Performance and Security performance by Cloudflare : If you are using CloudFlare enable it and fill up the other details otherwise disable it.

Leave all the other settings after this as they are.

Page Cache Settings

General:

  • Cache Front Page: Enable
  • Cache feeds: site, categories, tags, comments: Enable
  • Cache SSL (https) requests: I think, you aren’t using a secure connection,therefore, Disable it.
  • Cache URIs with query string variables: Disable
  • Cache 404 (not found) pages:  Enable
  • Cache requests only for www.wpcub.com site address: Enable
  • Don’t cache pages for logged in users: Enable(It’s good to enable this)
  • Don’t cache pages for following user roles: You may wish to enable this as per your preference.

Cache Preload

  • Automatically prime the page cache: Enable
  • Update interval: 18000
  • Pages per interval: 10
  • Sitemap URL: Add your sitemap URL (sitemap ends with .xml)

Purge Cache: Page Cache

No Change Required

Advanced

No Change Required

Minify Settings

General

  • Rewrite URL structure: Enable
  • Disable minify for logged in users: Disable
  • Minify error notification: Admin Notification(or as per your need)

HTML & XML

  • HTML minify settings: Enable and also enable all the sub-options
  • Ignored comment stems: Don’t change anything

JS

  • JS minify settings: Enable
  • Operation in Area: Minify (Non-Blocking using async)

 CSS

  • CSS minify settings: Enable
  • Combine only: Disable
  • Preserved comment removal: Disable
  • Line break removal: Enable
  • @import Handling: Process

Advanced

No Changed Required

 Database Cache Settings

General

  • Don’t cache queries for logged in users: Enable

Advance

No Changed Required

Object Cache Settings

No Changed Required

Browser Cache Settings

General

  • Set expires header: Enable
  • Set cache control header: Enable
  • Set entity tag (eTag): Enable
  • Set W3 Total Cache header: Enable
  • Enable HTTP (gzip) compression: Enable
  • Prevent caching of objects after settings change: Enable
  • – Enable
  • Do not process 404 errors for static objects with WordPress– Disable

 CSS and JS

  • Set expires header: Enable
  • Expires header lifetime: 31536000 seconds
  • Set cache control header: Enable
  • Cache Control Policy: cache with max-age
  • Set entity tag (eTag): Enable
  • Set W3 Total Cache header: Enable
  • Enable HTTP (gzip) compression: Enable
  • Prevent caching of objects after settings change – Disable
  • Remove cookies for static files: Enable

HTML and XML

  • Set expires header: Enable
  • Expires header lifetime : 3600 seconds
  • Set cache control header: Enable
  • Cache Control Policy: cache with max-age
  • Set entity tag (eTag): Enable
  • Set W3 Total Cache header: Enable
  • Enable HTTP (gzip) compression: Enable

Media and Other Files

  • Set expires header: Enable
  • Expires header lifetime: 31536000 seconds
  • Set cache control header: Enable
  • Cache Control Policy: cache with max-age
  • Set the entity tag (eTag): Enable
  • Set W3 Total Cache header: Enable
  • Enable HTTP (gzip) compression: Enable
  • Prevent caching of objects after settings change: Enable
  • Disable cookies for static files: Enable

 

That’s all for more info email us ..