Accidentally changed the Site URL in General Settings WordPress
- SOLVED
I need someone to manually change the site's URL and Home back to what they should be.
Site URL: www.StJohnsLacrosse.com/laxprogram
Site Home: www.StJohnsLacrosse.com
Answers (9)
Francisco Javier Carazo Gil answers:
Hi Patrick,
Don't worry. Go to phpMyAdmin find "site_url" into "wp_options" table and change it.
Francisco Javier Carazo Gil comments:
If you want SQL query:
UPDATE wp_options SET option_value = "http://www.StJohnsLacrosse.com" WHERE option_name = "site_url";
Francisco Javier Carazo Gil comments:
Or send me access to your database and I will set in a moment.
Francisco Javier Carazo Gil comments:
What Manoj says is another good option.
Patrick MacAdams comments:
i've tried and failed. if anyone can do this, send an email to [email protected]
Francisco Javier Carazo Gil comments:
Message sent.
Francisco Javier Carazo Gil comments:
Job is done :)
John Cotton answers:
They are entries in the wp_options table of the database - you can change them there..
(You can also [[LINK href="http://codex.wordpress.org/Editing_wp-config.php"]]edit your wp-config.php[[/LINK]] file)
Jerson Baguio answers:
just modify the database table under wp_options.. or just pm i can help you modify that
Jatin Soni answers:
I understood that you want to change Site URL as www.StJohnsLacrosse.com instead of www.StJohnsLacrosse.com/laxprogram
give me the access of the database. that will take a min to do
or
edit yourself into the databse
wp_options > siteurl (third) click on edit and change the option_value what you want
Manoj Raj answers:
update_option('siteurl','http://example.com');
update_option('home','http://example.com');
add this to functions.php and then enter the blog...
Ross Wilson answers:
You can also use the wordpress relocate method to recover the settings
[[LINK href="http://codex.wordpress.org/Changing_The_Site_URL#Relocate_method"]]http://codex.wordpress.org/Changing_The_Site_URL#Relocate_method[[/LINK]]
derekshirk answers:
I think you can also add this to your config.php in the root level of your Wordpress directory
define('WP_SITEURL', 'http://example.com');
define('WP_HOME', 'http://example.com');
MDan answers:
Hi Patrick,
You have 2 options:
1. To fix this issue if you have Cpanel:
Open up phpMyAdmin:
- Select the database in which your WP install resides
- Select wp_options table from the left hand side list
Now you need to modify 2 things:
siteurl (it has option_id number 1)
home (option_id 37)
You should backup your site before doing this!
http://codex.wordpress.org/WordPress_Backups#Simple_Backup
2. Follow the steps listed on the wordpress Codex:
http://codex.wordpress.org/Changing_The_Site_URL
Agus Setiawan answers:
Open up wp-config.php and paste these lines (with your site name) into it after the initial commenting:
define('WP_HOME', 'http://sitename.com');
define('WP_SITEURL', 'http://sitename.com');