There may instance where you made a mistake in Settings General and changed the urls by mistake
or
There are times when you change Domain Names and move to new host and you have data with old domain name or you are transferring website from a ip address url test site like http://ip address/~cpanel_username to a domain name and you need to change on posts as well.
You login on your host cpanel and click on PhpMyAdmin icon. Some host you will need to enter the database user name and password to go to PhpMyAdmin
Once in PhpMyAdmin you will see a list of database if you have more than one click on the database you need to work on.
First thing you need to do is backup your database by using export feature in PhpMyAdmin and save it as a sql file on your computer.
If you need to change the urls that are in Settings General the video below will show you how to change urls click on database option.
Step below is if you are changing your domain name
If you have posts and images on your wordpress chances are that the posts has old urls then you can change them by clicking on post table and click SQL option tab at top and add this code in box, be sure enter olddomain and newdomain with your domain names
UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';
and press Go
Once you have changed the urls you will need log in admin panel and reset your permalinks by changing to default settings and save and check your pages and posts and if all is working fine switch back to custom structure and add /%postname%/ and save.
Once you done the changes you should have your wordpress back with the changes.
Get the Flash Player to see the wordTube Media Player.
About Govindji Patel
I am Author/Publisher WordPress Coach and Consultant who enjoys writing tutorials and helping wordpress users build better WordPress website/blog.
Related Posts
-
Choice
-
sam
-
Govindji Patel
-
NHJS
-
Govindji Patel
-
brok
-
NDEZIN
-
Govindji Patel
Wordpress Coaching For Beginners
"Learn How To Finally Make Money From Your Blogs And Be A Guru In Any Niche With Step By Step Videos"
Discover how you can blog like othe successfull bloggers with simple step by step Techniques.
Discover how you can blog like othe successfull bloggers with simple step by step Techniques.- An Introduction to the system
- Finding a Niche Market
- Keyword swipe file
- How to make money from blog
- How to setup blog
- Maximizing blogging revenue
- Wrap Up
days
hours
minutes
seconds
Your privacy will never be compromised or shared.
Free Online Wordpress Webinar
Here is What You will Be Learning In Our Webinar:
- What is wordpress?
- What is the difference between wordpress.com and a self-hosted WordPress site?
- How to install wordpress on your host account or work on wordpress locally on your computer
- How to create and manage pages and posts while knowing the difference between the two
- How to use and work with sidebar widgets, themes, and plugins
- Where does the style come from in a WordPress site? What tool to use to make minor changes to your theme style, css file, etc.
- The power of plugins – where to find them and how to get them to work with a WordPress site
days
hours
minutes
seconds
Your privacy will never be compromised or shared.
Congratulations
Thank you for Subscribing Please check your email for a confirmation email
Thank you for Subscribing Please check your email for a confirmation email
Loading
-
I was having problems with wordpress and struggling to find help. Govindji responded to my support forum post, and took the time to review all the issues with me on Skype. He shared his vast knowledge with me in a way I could understand. Thank you for helping me resolve a unique problem that no [...]
-
Mr Govindji Patel saved me! i screwed up my website so bad and he helped me fix everything! for three or four days in a row he helped me step by step not only just fixing it but teaching me in the process. he went above and beyond what anyone else had done. i never [...]
-
Govindji Patel (govpatel) was very patient and have an understated brilliance to a query in wordpress. I expected him to go a mile as most do but he impressed me with more! Am definitely his number one fan! About Govindji Patel I am Author/Publisher WordPress Coach and Consultant who enjoys writing tutorials and helping wordpress [...]
-
