Mixing
Change site URL and WordPress URL in Localhost
I am work in Wordpress. And my system localhost url is http://localhost:8080/wordpress.
I want to shift our site another system.
My problem is that my another system localhost url is http://localhost/wordpress (not include 8080).
So can you help me that is how many table update in our database
wordpress
edited Apr 21 '15 at 8:26
Tim Castelijns
31.6k1289111
asked Apr 17 '15 at 10:49
vikal singhvikal singh
16112
add a comment |
I am work in Wordpress. And my system localhost url is http://localhost:8080/wordpress.
I want to shift our site another system.
My problem is that my another system localhost url is http://localhost/wordpress (not include 8080).
So can you help me that is how many table update in our database
wordpress
edited Apr 21 '15 at 8:26
Tim Castelijns
31.6k1289111
asked Apr 17 '15 at 10:49
vikal singhvikal singh
16112
add a comment |
I am work in Wordpress. And my system localhost url is http://localhost:8080/wordpress.
I want to shift our site another system.
My problem is that my another system localhost url is http://localhost/wordpress (not include 8080).
So can you help me that is how many table update in our database
wordpress
edited Apr 21 '15 at 8:26
Tim Castelijns
31.6k1289111
asked Apr 17 '15 at 10:49
vikal singhvikal singh
16112
I am work in Wordpress. And my system localhost url is http://localhost:8080/wordpress.
I want to shift our site another system.
My problem is that my another system localhost url is http://localhost/wordpress (not include 8080).
So can you help me that is how many table update in our database
wordpress
wordpress
edited Apr 21 '15 at 8:26
Tim Castelijns
31.6k1289111
asked Apr 17 '15 at 10:49
vikal singhvikal singh
16112
edited Apr 21 '15 at 8:26
Tim Castelijns
31.6k1289111
asked Apr 17 '15 at 10:49
vikal singhvikal singh
16112
edited Apr 21 '15 at 8:26
Tim Castelijns
31.6k1289111
edited Apr 21 '15 at 8:26
Tim Castelijns
31.6k1289111
edited Apr 21 '15 at 8:26
Tim Castelijns
31.6k1289111
31.6k1289111
asked Apr 17 '15 at 10:49
vikal singhvikal singh
16112
asked Apr 17 '15 at 10:49
vikal singhvikal singh
16112
asked Apr 17 '15 at 10:49
vikal singhvikal singh
16112
16112
add a comment |
add a comment |
4 Answers
4
active
oldest
votes
I use the following queries to update domain name of the site
UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'home';
UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'siteurl';
UPDATE wp_posts
SET post_content = REPLACE(post_content,'http://old-domain-name.com','http://new-domain-name.com');
UPDATE wp_posts
SET guid = REPLACE(guid,'http://old-domain-name.com','http://new-domain-name.com');
Just change http://old-domain-name.com and http://new-domain-name.com to appropriate domain names. This should help you.
answered Apr 17 '15 at 10:55
iuriiiurii
2,71611322
Thanks this is very helpfull for me...
– vikal singh
Apr 17 '15 at 15:17
This is very nicely written and super easy to read. I've adapted your code in an answer here and linked it back to you.
– Frits
Jul 24 '17 at 18:05
add a comment |
Search replace db is a good tool to replace all old url with new urls. You can download latest file from
seach replace db
Perform following steps
- put the file on wp directory
- open wp config file and change database credentials
- open url in browser (http://localhost/wordpress/downloadedfile.php)
- read instruction and go to next step till it complete.
This tool help you to upload or migrate database from localhost to server or server to server.
edited Oct 30 '16 at 11:20
Vivek S.
10.8k53568
answered Apr 17 '15 at 11:03
Manish ShuklaManish Shukla
1,1622721
add a comment |
Log in to your WordPress control panel (http://coolexample.com/wp-admin, where coolexample.com is your domain name).
Click Settings, and then click General.
In the WordPress address (URL) and Site address (URL) fields, enter the new domain name or URL you want to use, and then click Save Changes.
see:
https://www.godaddy.com/help/changing-your-wordpress-domain-name-6495
answered Nov 4 '17 at 4:26
Marco RubioMarco Rubio
513
add a comment |
You have to be very careful about the search and replace and ensure that any serialized data in any of your tables is properly unpacked, updated and re-packed.
If your target site is usable you can use various things to update its data to use the new URL format.
If you're comfortable with the command line you can use the WP-CLI with a command like:
wp search-replace http://localhost:8080/wordpress http://localhost/wordpress
For a WordPress Admin Dashboard tool I'd recommend the free Better Search Replace plugin.
If the URL needs to be changed before loading the data into the new site's database, I'd recommend using the free WP Migrate DB plugin to export your database with a find/replace pair of "//localhost:8080/wordpress" and "//localhost/wordpress" (without quotes). You can then run the exported SQL file against your target site's database.
answered Apr 17 '15 at 11:34
ianmjonesianmjones
2,90711922
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f29697144%2fchange-site-url-and-wordpress-url-in-localhost%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
4 Answers
4
active
oldest
votes
4 Answers
4
active
oldest
votes
active
oldest
votes
active
oldest
votes
I use the following queries to update domain name of the site
UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'home';
UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'siteurl';
UPDATE wp_posts
SET post_content = REPLACE(post_content,'http://old-domain-name.com','http://new-domain-name.com');
UPDATE wp_posts
SET guid = REPLACE(guid,'http://old-domain-name.com','http://new-domain-name.com');
Just change http://old-domain-name.com and http://new-domain-name.com to appropriate domain names. This should help you.
answered Apr 17 '15 at 10:55
iuriiiurii
2,71611322
Thanks this is very helpfull for me...
– vikal singh
Apr 17 '15 at 15:17
This is very nicely written and super easy to read. I've adapted your code in an answer here and linked it back to you.
– Frits
Jul 24 '17 at 18:05
add a comment |
I use the following queries to update domain name of the site
UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'home';
UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'siteurl';
UPDATE wp_posts
SET post_content = REPLACE(post_content,'http://old-domain-name.com','http://new-domain-name.com');
UPDATE wp_posts
SET guid = REPLACE(guid,'http://old-domain-name.com','http://new-domain-name.com');
Just change http://old-domain-name.com and http://new-domain-name.com to appropriate domain names. This should help you.
answered Apr 17 '15 at 10:55
iuriiiurii
2,71611322
Thanks this is very helpfull for me...
– vikal singh
Apr 17 '15 at 15:17
This is very nicely written and super easy to read. I've adapted your code in an answer here and linked it back to you.
– Frits
Jul 24 '17 at 18:05
add a comment |
I use the following queries to update domain name of the site
UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'home';
UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'siteurl';
UPDATE wp_posts
SET post_content = REPLACE(post_content,'http://old-domain-name.com','http://new-domain-name.com');
UPDATE wp_posts
SET guid = REPLACE(guid,'http://old-domain-name.com','http://new-domain-name.com');
Just change http://old-domain-name.com and http://new-domain-name.com to appropriate domain names. This should help you.
answered Apr 17 '15 at 10:55
iuriiiurii
2,71611322
I use the following queries to update domain name of the site
UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'home';
UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'siteurl';
UPDATE wp_posts
SET post_content = REPLACE(post_content,'http://old-domain-name.com','http://new-domain-name.com');
UPDATE wp_posts
SET guid = REPLACE(guid,'http://old-domain-name.com','http://new-domain-name.com');
Just change http://old-domain-name.com and http://new-domain-name.com to appropriate domain names. This should help you.
answered Apr 17 '15 at 10:55
iuriiiurii
2,71611322
answered Apr 17 '15 at 10:55
iuriiiurii
2,71611322
answered Apr 17 '15 at 10:55
iuriiiurii
2,71611322
answered Apr 17 '15 at 10:55
iuriiiurii
2,71611322
2,71611322
Thanks this is very helpfull for me...
– vikal singh
Apr 17 '15 at 15:17
This is very nicely written and super easy to read. I've adapted your code in an answer here and linked it back to you.
– Frits
Jul 24 '17 at 18:05
add a comment |
Thanks this is very helpfull for me...
– vikal singh
Apr 17 '15 at 15:17
This is very nicely written and super easy to read. I've adapted your code in an answer here and linked it back to you.
– Frits
Jul 24 '17 at 18:05
Thanks this is very helpfull for me...
– vikal singh
Apr 17 '15 at 15:17
Thanks this is very helpfull for me...
– vikal singh
Apr 17 '15 at 15:17
This is very nicely written and super easy to read. I've adapted your code in an answer here and linked it back to you.
– Frits
Jul 24 '17 at 18:05
This is very nicely written and super easy to read. I've adapted your code in an answer here and linked it back to you.
– Frits
Jul 24 '17 at 18:05
add a comment |
Search replace db is a good tool to replace all old url with new urls. You can download latest file from
seach replace db
Perform following steps
- put the file on wp directory
- open wp config file and change database credentials
- open url in browser (http://localhost/wordpress/downloadedfile.php)
- read instruction and go to next step till it complete.
This tool help you to upload or migrate database from localhost to server or server to server.
edited Oct 30 '16 at 11:20
Vivek S.
10.8k53568
answered Apr 17 '15 at 11:03
Manish ShuklaManish Shukla
1,1622721
add a comment |
Search replace db is a good tool to replace all old url with new urls. You can download latest file from
seach replace db
Perform following steps
- put the file on wp directory
- open wp config file and change database credentials
- open url in browser (http://localhost/wordpress/downloadedfile.php)
- read instruction and go to next step till it complete.
This tool help you to upload or migrate database from localhost to server or server to server.
edited Oct 30 '16 at 11:20
Vivek S.
10.8k53568
answered Apr 17 '15 at 11:03
Manish ShuklaManish Shukla
1,1622721
add a comment |
Search replace db is a good tool to replace all old url with new urls. You can download latest file from
seach replace db
Perform following steps
- put the file on wp directory
- open wp config file and change database credentials
- open url in browser (http://localhost/wordpress/downloadedfile.php)
- read instruction and go to next step till it complete.
This tool help you to upload or migrate database from localhost to server or server to server.
edited Oct 30 '16 at 11:20
Vivek S.
10.8k53568
answered Apr 17 '15 at 11:03
Manish ShuklaManish Shukla
1,1622721
Search replace db is a good tool to replace all old url with new urls. You can download latest file from
seach replace db
Perform following steps
- put the file on wp directory
- open wp config file and change database credentials
- open url in browser (http://localhost/wordpress/downloadedfile.php)
- read instruction and go to next step till it complete.
This tool help you to upload or migrate database from localhost to server or server to server.
edited Oct 30 '16 at 11:20
Vivek S.
10.8k53568
answered Apr 17 '15 at 11:03
Manish ShuklaManish Shukla
1,1622721
edited Oct 30 '16 at 11:20
Vivek S.
10.8k53568
edited Oct 30 '16 at 11:20
Vivek S.
10.8k53568
edited Oct 30 '16 at 11:20
Vivek S.
10.8k53568
10.8k53568
answered Apr 17 '15 at 11:03
Manish ShuklaManish Shukla
1,1622721
answered Apr 17 '15 at 11:03
Manish ShuklaManish Shukla
1,1622721
answered Apr 17 '15 at 11:03
Manish ShuklaManish Shukla
1,1622721
1,1622721
add a comment |
add a comment |
Log in to your WordPress control panel (http://coolexample.com/wp-admin, where coolexample.com is your domain name).
Click Settings, and then click General.
In the WordPress address (URL) and Site address (URL) fields, enter the new domain name or URL you want to use, and then click Save Changes.
see:
https://www.godaddy.com/help/changing-your-wordpress-domain-name-6495
answered Nov 4 '17 at 4:26
Marco RubioMarco Rubio
513
add a comment |
Log in to your WordPress control panel (http://coolexample.com/wp-admin, where coolexample.com is your domain name).
Click Settings, and then click General.
In the WordPress address (URL) and Site address (URL) fields, enter the new domain name or URL you want to use, and then click Save Changes.
see:
https://www.godaddy.com/help/changing-your-wordpress-domain-name-6495
answered Nov 4 '17 at 4:26
Marco RubioMarco Rubio
513
add a comment |
Log in to your WordPress control panel (http://coolexample.com/wp-admin, where coolexample.com is your domain name).
Click Settings, and then click General.
In the WordPress address (URL) and Site address (URL) fields, enter the new domain name or URL you want to use, and then click Save Changes.
see:
https://www.godaddy.com/help/changing-your-wordpress-domain-name-6495
answered Nov 4 '17 at 4:26
Marco RubioMarco Rubio
513
Log in to your WordPress control panel (http://coolexample.com/wp-admin, where coolexample.com is your domain name).
Click Settings, and then click General.
In the WordPress address (URL) and Site address (URL) fields, enter the new domain name or URL you want to use, and then click Save Changes.
see:
https://www.godaddy.com/help/changing-your-wordpress-domain-name-6495
answered Nov 4 '17 at 4:26
Marco RubioMarco Rubio
513
answered Nov 4 '17 at 4:26
Marco RubioMarco Rubio
513
answered Nov 4 '17 at 4:26
Marco RubioMarco Rubio
513
answered Nov 4 '17 at 4:26
Marco RubioMarco Rubio
513
513
add a comment |
add a comment |
You have to be very careful about the search and replace and ensure that any serialized data in any of your tables is properly unpacked, updated and re-packed.
If your target site is usable you can use various things to update its data to use the new URL format.
If you're comfortable with the command line you can use the WP-CLI with a command like:
wp search-replace http://localhost:8080/wordpress http://localhost/wordpress
For a WordPress Admin Dashboard tool I'd recommend the free Better Search Replace plugin.
If the URL needs to be changed before loading the data into the new site's database, I'd recommend using the free WP Migrate DB plugin to export your database with a find/replace pair of "//localhost:8080/wordpress" and "//localhost/wordpress" (without quotes). You can then run the exported SQL file against your target site's database.
answered Apr 17 '15 at 11:34
ianmjonesianmjones
2,90711922
add a comment |
You have to be very careful about the search and replace and ensure that any serialized data in any of your tables is properly unpacked, updated and re-packed.
If your target site is usable you can use various things to update its data to use the new URL format.
If you're comfortable with the command line you can use the WP-CLI with a command like:
wp search-replace http://localhost:8080/wordpress http://localhost/wordpress
For a WordPress Admin Dashboard tool I'd recommend the free Better Search Replace plugin.
If the URL needs to be changed before loading the data into the new site's database, I'd recommend using the free WP Migrate DB plugin to export your database with a find/replace pair of "//localhost:8080/wordpress" and "//localhost/wordpress" (without quotes). You can then run the exported SQL file against your target site's database.
answered Apr 17 '15 at 11:34
ianmjonesianmjones
2,90711922
add a comment |
You have to be very careful about the search and replace and ensure that any serialized data in any of your tables is properly unpacked, updated and re-packed.
If your target site is usable you can use various things to update its data to use the new URL format.
If you're comfortable with the command line you can use the WP-CLI with a command like:
wp search-replace http://localhost:8080/wordpress http://localhost/wordpress
For a WordPress Admin Dashboard tool I'd recommend the free Better Search Replace plugin.
If the URL needs to be changed before loading the data into the new site's database, I'd recommend using the free WP Migrate DB plugin to export your database with a find/replace pair of "//localhost:8080/wordpress" and "//localhost/wordpress" (without quotes). You can then run the exported SQL file against your target site's database.
answered Apr 17 '15 at 11:34
ianmjonesianmjones
2,90711922
You have to be very careful about the search and replace and ensure that any serialized data in any of your tables is properly unpacked, updated and re-packed.
If your target site is usable you can use various things to update its data to use the new URL format.
If you're comfortable with the command line you can use the WP-CLI with a command like:
wp search-replace http://localhost:8080/wordpress http://localhost/wordpress
For a WordPress Admin Dashboard tool I'd recommend the free Better Search Replace plugin.
If the URL needs to be changed before loading the data into the new site's database, I'd recommend using the free WP Migrate DB plugin to export your database with a find/replace pair of "//localhost:8080/wordpress" and "//localhost/wordpress" (without quotes). You can then run the exported SQL file against your target site's database.
answered Apr 17 '15 at 11:34
ianmjonesianmjones
2,90711922
edited May 25 '18 at 9:01
answered Apr 17 '15 at 11:34
ianmjonesianmjones
2,90711922
answered Apr 17 '15 at 11:34
ianmjonesianmjones
2,90711922
answered Apr 17 '15 at 11:34
ianmjonesianmjones
2,90711922
2,90711922
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f29697144%2fchange-site-url-and-wordpress-url-in-localhost%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
