my wordpress configuration locally vs live server

by

You just need setup couple things for it.

  1. Make Database Backup from your localhost

  2. Copying all files and folders from your local to the host

  3. Adjust wp-config.php following your live site configurations.

  4. Import database to live site

  5. Replace all local urls with live site have. You can use this query for it

    UPDATE wp_options SET option_value = replace(option_value, ‘oldurl.com’, ‘newurl.com’) WHERE option_name=”home” OR option_name=”siteurl”;

    UPDATE wp_posts SET guid = replace(guid, ‘oldurl.com’,’newurl.com’);

    UPDATE wp_posts SET post_content = replace(post_content, ‘oldurl.com’, ‘newurl.com’);

    UPDATE wp_postmeta SET meta_value = replace(meta_value,’oldurl.com’,’newurl.com’);