Changing the URL directly in the database
If you installed wordpress to a site and placed the enitre install and all of your pages into a “WordPress” directory or other directory within the root of your site, and you want to move all of these files to become the main root files of your site, you will need to do a URL directory change. I have tried a lot of the options presented at the link below from the Official WordPress site, but the technique I provide below is what worked best for me.
If you know how to access phpMyAdmin on your host, then you can edit these values directly to get you up and running again.
1. Backup your database and save the copy off-site.
2. Login to phpMyAdmin.
3. Click the link to your Databases.
4. A list of your databases will appear. Choose the one that is your WordPress database.
5. All the tables in your database will appear on the screen.
6. From the list, look for wp_options. Note: The table prefix of wp_ may be different if you changed it when installing.
7. Click on the small icon indicated as Browse.
8. A screen will open with a list of the fields within the wp_options table.
9. Under the field option_name, scroll down and look for siteurl.
10. Click the Edit Field icon which usually is found at the far left at the beginning of the row.
11. The Edit Field window will appear.
12. In the input box for option_value, carefully change the URL information to the new address.
13. Verify this is correct and click Go to save the information.
14. You should be returned to your wp-options table.
15. Look for the home field in the table and click Edit Field. Note There are several pages of tables inside wp_options. Look for the > symbol to page through them.
16. In the input box for option_value, carefully change the URL information to the new address.
17. Verify this is correct and click Go to save the information.
18. Delete the folder wp-content/cache (this is a new folder added with WordPress 2.0).
19. That is it.
Related Posts via Categories
- How to Change Absolute Links
- Exporting and Importing WordPress Databse
- Multiple WordPress installations on a single database
- Change Role Names or Add new Roles in WordPress
- Word Press Error 404
- WordPress Perma Links Setting
- Install Multiple WordPress Installations Using a Single Database
- WordPress Plugins I love
- WordPress 1and1 Server 500 Internal Server Errors and NexGen Gallery
- WordPress 3.0.1 Image Upload Error
- How to decode encrypted WordPress footers
- How To Remove Author Details from posts In WordPress Blog
- Private: Privacy
- Offering More Subscription Options
- How to make money as a welder and market your skill
- Private: Sites
- Tri-Magnum – R.Q. Riley
- VTR “S”
- Tips for using Google AdWords
- Photography Backgrounds
- How to write popular and useful ehow articles
- Tri-Magnum Project Car