How to migrate Wordpress site from localhost to live server?

Ready to move your WordPress site from your local computer to a live server? If you've been working on your WordPress website locally, it's time to share it with the world. Learn how to make this transition seamlessly in just a few steps. That is running fine at local server and now it need to move on live server. I'm going to write you about in this artical "How to migrate wordpress website local to live server" Step 1 - Export Database File To start, open up your local server and go to phpMyAdmin just type http://localhost/phpmyadmin into the address bar and export database.

Step 2 - Take Backup of all wordpress files open up your local server main site directory zip it and upload this zip to live server then extract it.

Step 3 - Create New Database and Import Create new database at new live server with username then import database sql file into new database.
Step 4 - Upload all files of wordpress

Unzip backup zip file on the new live server and extract it. Then open up "wp-confiq.php" file change database details That's it. Now check your site. You will see your website that has restored successfully. Step 5 - Change urls through database.

That's most import thing to do with full your attention. Search old site urls and replace with new site urls by running sql query. Here is the Query that you will run by SQL tab through database. ------------------------------------------------------- ------------------------------------------------------- UPDATE wp_posts SET guid = REPLACE( guid, "olddomain.com/wordpress", "www.newdomain.com" ); ------------------------------------------------------- ------------------------------------------------------- That's it. Hoping this article will help you. Kindly like and share and follow my blog :
http://www.cmsserviceprovider.blogspot.in
Click for video tutorials

How to Reset a WordPress Password from phpMyAdmin?

First of all you will need to know about database of wordpress website. Just login into cpanel then open your wp-config.php file which is located in your root WordPress folder at cpanel. In there you will find the name of your database. In cpanel you will need to access your MySQL database through phpMyAdmin. Select the correct database from the left-hand side for a seamless process.

Click on the table "wp_users" in the list of tables and browse table

You will notice that there are a lot of random characters in the password field. Due to security reasons, WordPress stores the passwords as MD5 Hash instead plain text. Just copy and paste pre-coded secret password to reset password. Once you reset password go to admin panel and you can change password through admin profile. That's it. Hoping this article will help you. Kindly like and share and follow my blog :
http://www.cmsserviceprovider.blogspot.in