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');
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.
