How to Migrate Word Press site into Live server from Local Server

Last Updated on May 16, 2018

If you want to migrate your site from local server (localhost) to live server, their are various techniques to migrating. Either you can do it manually or use different plugin available in the repository. Before migrating your sit , it would be better to backup your themes,plugin and database.
If you are new to word press and unknown about how to upload on live server, it is quite simple task, just follow the procedure as follows:
1. Install the word press (latest version) on your site. Don’t Know how to copy?
2. Download/ Copy your wp content file from your local server or old server.
3. Using FTP copy your all wp content in live server’s wp content folder. Don’t Know how to create FTP account?
4. Create new Database from Cpanel . Dont know How to create new database from Cpanel ?
5. Create user and assign database to the user and also grant privileged for user.
6. Now import your (local server/old site) database backup into live server.
7. Finally update the URL’s via the sql Query. This step is very much important and done carefully.
8. Run the Migrate SQL query in your live server .(if required)

UPDATE wp_options SET option_value = replace(option_value, ‘http://www.oldsite.com’, ‘http://www.newsite.com’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;

[wp-notes-widget title=”” thumb-tack-color=”green” text-color=”black” background-color=”blue” font-size=”plus-15″ show-notes=”495″ show-date=”false” use-own-css=”false” hide-if-empty=”false” multiple-notes=”false” social-sharing=”false” no-uppercase=”false” font-style=”kalam” max-width=”100%” alignment=”left” direction=”vertical” ]

UPDATE wp_posts SET guid = replace(guid, ‘http://www.oldsite.com’,’http://www.newsite.com’);
UPDATE wp_posts SET post_content = replace(post_content, ‘http://www.oldsite.com’, ‘http://www.newsite.com’);
UPDATE wp_postmeta SET meta_value = replace(meta_value, ‘http://www.oldsite.com’, ‘http://www.newsite.com’);
9. wait wait wait … don’t forget to change your table prefix (according to your local server).