How to Move WordPress Blog to New Domain or Location
For blogger who self-hosts the WordPress blog publishing system on a web hosting server with own registered domain name, sometimes, you may decide to reorganize the blog link URL to make it tidier or to reflect new focus or theme of the blog. If you decide to change the URL or link location of your WordPress blog due to changing of domain name (such as from http://www.old-domain.com/ to http://www.new-domain.com/) or the blog to another directory location (such as from http://www.domain.com/ to http://www.domain.com/blog/), there are some steps that should be done to ensure the proper migration and no breaking links.
The tricky part when moving WordPress blog to another location is that WordPress is using absolute path in URL link instead of relative path in URL link location when stores some parameters in database. Within blog posts’ contents itself, users may also use the old URLs when creating reference backlinks. All these values in the database will need to be changed when WordPress is moved. The following guide will show you which database fields that has references or values related to blog’s URLs that you want to modify. Note that this guide is not about how to move WordPress blog from one server or host to another new hosting service.
Once the blog has been moved (all files copy over in case of moving location or server or new domain name properly propagated across Internet for new domain name), the first thing to change is to tell WordPress the new blog location (wp-config.php should be no changes, and .htaccess file should be also no changes. If for some reason mod_rewrite rules for friendly URLs no longer works, you can always regenerate the .htaccess file via WP Administration’s Update Permalinks page). This value can be changed via WordPress Options page, but if you no longer able to access to old blog URL, you have to modify the value via MySQL database.
Note: The guide uses SQL statements based on MySQL replace() function to modify the database. To run SQL queries, login to MySQL database that houses WordPress tables via phpMyAdmin or login to the DB server and run MySQL client as root.
To update WordPress options with the new blog location, use the following SQL command:
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';
After that you will need to fix URLs of the WordPress posts and pages, which translated from post slug, and stored in database wp_posts table as guid field. The URL values in this field are stored as absolute URLs instead of relative URLs, so it needs to be changed with the following SQL query:
UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');
If you have linked internally within blog posts or pages with absolute URLs, these links will point to wrong locations after you move the blog location. Use the following SQL commands to fix all internal links to own blog in all WordPress posts and pages:
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');
Browse through WordPress blog to check if everything is okay. You also need to re-login to WP Administration as authentication cookie has now became invalid due to different domain.
Related Articles
- Using PHP-MySQL Persistent Connections to Run WordPress Blog
- Replace Google Blog Search with Technorati for Incoming Links in Dashboard of WordPress
- WLWManifest Disabler Plugin to Remove XLM Link in WordPress Blog Header
- AdSense and Display Banner Ads Rotation in WordPress Blog or Websites
- How to List and Show WordPress Posts That Comments and Pings Off (Not Allow)
- Moderate WordPress Blog Comments Via Moderator with Desktop Client
- How to Rename or Move Oracle Tablespace Datafile to Another Location
- Google Domain Names Registration and Search for Free Apps for Your Domain
- Integrate and Display Google AdSense for Search and Co-Op Custom Search Engine Results in WordPress Blog Page Template
- How to Delete Existing WordPress Post Revisions Stored/Saved
Entries (RSS)
November 8th, 2009 10:38
[...] How to Move WordPress Blog to New Domain or Location SHARETHIS.addEntry({ title: "Copying a WordPress Blog to a Different Domain", url: "http://dpotter.net/Technical/2009/11/copying-a-wordpress-blog-to-a-different-domain/" }); Email this article Print this article [...]
November 5th, 2009 11:24
There is nothing I could find on the WP codex that describes these completely essential steps of the migration process completely. Also, the MySQL commands is by far the most difficult bit to understand. Awesome stuff and thanks. I followed your steps and it works (and I understand it too).
November 5th, 2009 05:16
Thank you..
Now I can sleep again..
November 5th, 2009 01:36
I just want to say thank you very much for this article and for your time creating these SQL statements.
Can i say I Love You?!?! haha
Thanks,
Kelsi Guidry
November 4th, 2009 00:56
The only issue I found was that the new site keeps trying to upload media to the old site. Is there an easy way for me to change this? Where would I look?
October 31st, 2009 08:57
Thanks so much for the help for me to merge my blogs. You saved me a tonne of headaches.
October 29th, 2009 19:25
It’s it not necessary to do anything in database for migrate the url to another domain.
There is another way with this simple steps.
1. change Blog address and Wordpress adresse (Url) in your general settings -> safe changes
2. go to settings -> permalinks do nothing and save changes
so the blog urls been updated.
please give me a response …
greetz Markus
October 26th, 2009 23:01
Thank you for this advice. It really helped me.
Sam
October 17th, 2009 17:41
Thanks for the tips !
October 6th, 2009 04:18
[...] need to edit, these articles will steer you to the right place: Moving WordPress WordPress Codex How to Move WordPress Blog to New Domain or Location My Digital Life To REALLY automate this you could write an install script that copied and expanded the files, [...]
October 1st, 2009 11:35
I followed the above steps for moving to a new location in my server and also a new domain name. While everything works fine I am not able to login to wp admin. It takes the user p/w but gives me HTTP 403 error in internet explorer. Please help.
September 19th, 2009 18:18
Thanks for making this tutorial, now my problem is solved. Thanks.
September 17th, 2009 19:13
thancks
this post very very helped me !
Good Time
September 14th, 2009 01:07
For me a much easier way to do it is:
1. Do a database dump with the mysqldump command.
2. Replace all occurrences of http://oldsite to http://newsite
3. Restore the database with the modified dump
September 13th, 2009 15:52
Just wanted to say, thank you – this post was a big help.
September 10th, 2009 06:30
Why don’t you just change the domain in the options just before your ready to move. That’s how I did it and it worked great.
September 5th, 2009 20:03
Great information for sure, but I confess it seems too much work for my purposes. I think I will keep the domain I have. Thanks.
August 27th, 2009 15:59
thx a lot. It seems a lot easier than I thought. Implementing this on my blog was quicker than writing my post above.
August 12th, 2009 13:02
[...] you’ve followed the standard operating procedure for moving the blog, and all database entries are updated to the new path (I did this part manually, but the linked procedure seems OK), the most likely [...]
August 9th, 2009 22:24
Thanks for the essay.
Can I put this essay to my general content site?
Thank you so much again.
August 5th, 2009 08:45
Thanks for the info – don’t forget to post about the Australian domain name industry – it’s really starting to take off… Thanks again
August 4th, 2009 23:32
man, you rock. This just saved me an hour of head-banging. worked like a charm the first time.
thanks!
July 31st, 2009 17:19
[...] How to Move WordPress Blog to New Domain or Location [...]
July 27th, 2009 18:17
Great Post, saved me ages, many thanks!
July 16th, 2009 11:33
[...] made the migration using this fantastic post on how to move a Wordpress blog to a new domain. So, update your RSS feeds and I’ll see you over there. Category: Uncategorized [...]
July 16th, 2009 01:43
[...] how do i change the domian of my blog , just bought a new.. How to Move WordPress Blog to New Domain or Location My Digital Life [...]
July 15th, 2009 03:08
[...] v angličtině viz My digital life. [...]
July 14th, 2009 17:42
lifesaver! thanks for this, have been scratching my head for a week or so trying to solve it on my own.. thanks
July 14th, 2009 15:36
[...] enkele parameters in je database (nieuwe url). Hier een overzichtje met de te nemen [...]
July 13th, 2009 12:53
I just imported 175 posts from a Blogspot fiction blog into a new Wordpress blog that a friend is offering to host for free! Problem is, I was using a custom book-inspired layout that showed one post at a time, with a series of menus linking the various posts together. Now all those menu links still point to the old posts at Blogger.com. Would the above technique convert those links quickly once the WP blog is hosted? Cause right now I’m resorting to cutting and pasting…
July 12th, 2009 06:45
[...] Reference: How to Move WordPress Blog to New Domain or Location [...]
July 11th, 2009 04:33
Thanks for the info, great guide for moving a WP site – I send people to this page all the time when they ask me how to do it.
July 9th, 2009 21:21
thankyou for the nice and helpful information.
July 8th, 2009 16:02
I was really confused why things were pointing back to the old domain. This guide made it really easy for me.
Thank you so much!
July 8th, 2009 00:56
I just moved 3 of mine using this guide. Made it easy for me. thanks
July 4th, 2009 10:43
Тhank you very much, very useful info.
July 3rd, 2009 13:37
worked perfectly – many thanks !
July 3rd, 2009 10:37
Thank you so much for this! I just had to transfer my blog to a new site and this was very concise and helpful.
June 19th, 2009 03:51
I couldn’t have done it without you!! Worked perfectly and very simple. Thanks.
June 16th, 2009 09:03
after moved my blog in to new host i can’t login my blog ??
Why ??
June 4th, 2009 19:39
Thanks so much for this!
June 4th, 2009 19:21
Discover the beauty of pakistan. Learn the culture, heritage, traditions and landmarks of different parts of Pakistan especially sindh, punjab, balochistan and N.W.F.P and far northern areas.
June 2nd, 2009 21:32
Thanks Great Help
May 27th, 2009 18:08
Just moved my blog to my new domain http://www.incomesinternationl.com.
Worked perfectly.
Thanks, I appreciate your work.
For those that are having trouble, when using phpmyadmin, make sure you click on the SQL tab then copy in the the 3 queries that have been provided here. Make sure you change the vales for the old-domain.com and new-domain.com and that is all that you will need to do.
Andrew Kolyvas
May 24th, 2009 01:20
Thank you. This worked perfectly.
May 20th, 2009 13:49
it works perfectly.Thank you for sharing this great information with us.
May 17th, 2009 04:46
Brilliant – worked perfectly – many thanks !
May 14th, 2009 03:25
You totally saved me I never would have known how to fix it! Thanks so much!
May 14th, 2009 01:33
Awesome info, this saved me some great webmastering time! Thanks!
May 9th, 2009 08:14
Thank you. This worked perfectly. =]
All I did was copy and paste. =]
May 6th, 2009 10:00
Great article. I just moved my WordPress 2.7.1 blog from one domain to another (same server, same MySQL database). A couple lessons learned:
1. It’s REALLY important that you get your quotes ” correct. I cut & pasted the SQL commands and they didn’t work the first time because the single quotes were too fancy – I typed over them and all was good.
2. The odd thing was that the three SQL commands didn’t change a single thing. I believe that the two plugins had already made all the required domain name changes.
3. There is a wee bit more editing that you need to do in the MySQL DB – you can do it via phpmyadmin. The tables _users, _usermetadata, and _options all need to be reviewed and all occurrences of your old_domain need to be replaced with your new_domain.
4. THIS IS THE ONE THAT GOT ME: please be aware that phpmyadmin will only display the first 30 or so columns of data in a given table. The _options table has MANY more columns than 30. If you forget to change ALL of the occurrences of your old_domain, then you may encounter a “You are not authorized to view this page” error when you log into WP after making your changes.
5. Don’t forget to edit your wp-config.php file in order to change the name of the MySQL database tables being used in the $table_prefix variable.
Good luck and make a backup of your database BEFORE you start!
- Dr. Jim Anderson
April 17th, 2009 08:53
[...] This trick came from an excellent post over at My Digital Life [...]
April 14th, 2009 10:40
[...] mysql commands – Move wp and change “home” and [...]
April 4th, 2009 23:48
[...] As I said I typically search for this information whenever I need to move Wordpress sites. I find the SQL queries at: http://www.mydigitallife.info/2007/10/01/how-to-move-wordpress-blog-to-new-domain-or-location/ [...]
March 31st, 2009 21:08
Yeah, I had that problem with my domain too. I bought a new domain name and when i was transfering my blog onto the new domain, all messed up and i lost a lots of my data:(
Anyway i recovered after some time, it was obviously in the beginning.
But i’m sure information you have provided here will be helpful to may others who are looking forward to shift their blog to a new domain name.
March 31st, 2009 20:02
Hello, i have installed wordpress to domain.org, but i need to have domain.com as main domain (domain.org i wolud lik to be parked) of that installation. If ponit name servers (domain.com) to hosting where is wordpress installed would by blog work??
March 23rd, 2009 11:01
[...] I’ve moved domains, the databases needed some work to fix links. I found an article that was of help, but what you basically do [...]
March 20th, 2009 22:48
works perfectly. thanks!
March 20th, 2009 04:53
Hi, folks!
I’m beginning to transfer the content of a free WP.COM blog to a payed domain and hosting service that supports WP but I still can’t do it. ;(
How is the procedure when I need to transfer all content posted on a free WORDPRESS.COM to a payed hosting service with my own domain?
I want to transfer my wordpress.2009-03-19.xml from heliopaz.wordpress.com to heliopaz.com but the wp-admin doesn’t allow me to upload a XML heavier than just 2 MB and my XML has 13.7 MB.
My host provides a great job but the online chat couldn’t help me and I’m waiting so long for the helpdesk response.
Any solution? May I have to ask my host (or even pay a few more bucks) to increase the space from 2 MB to 15 MB on my heliopaz.com wp-admin page?
Or could I use a FTP software to upload my XML file to a specific directory? In this case, where exactly I have to upload this file?
Thanks a lot!
Hélio Sassen Paz
Porto Alegre/RS
Brazil
March 17th, 2009 23:36
[...] tables and rename them to the proper domain name url. I found this information from this great post here. But the long and short of it is run the following [...]
March 12th, 2009 18:38
Excellent post, thanks for sharing, you’ve just saved me loads of time messing about
March 5th, 2009 08:38
[...] So I searched the web and got this tutorial. [...]
March 3rd, 2009 14:30
This was a great help to me, thanks! I’d just like to add that in WP 2.7 I also had to got to settings>permalinks and hit the save button again to reset those (I’m using ‘pretty’ permalinks.
February 25th, 2009 21:57
Great guide here for managing WP sites. Many thanks!
February 24th, 2009 03:41
Great stuff
Clear and easy to follow, just how a help page should be. Bookmarked for future reference.
February 24th, 2009 03:11
Wow, thanks! I was really afraid to do this (without knowing if I was doing it correctly), so I just decided to go for it and copy-paste 1-2-3. It worked! Note: also, I had to go take out the old index placeholder file I had up there at the designated location. Once that was out of the way, it all showed up.
many thanks again – most helpful!
February 22nd, 2009 15:42
Thanks, this helped me a lot. We are currently moving 2 WP-blogs to a new location.
February 19th, 2009 04:53
worked perfectly. one thing to consider is you have to be patient. it took about 15 min for the changes to propogate even after i cleared my cache. i know it makes no sense but thats the story!
February 11th, 2009 18:56
[...] MySQL Dump Importer If you are moving to a new domain I would also recommend to read this: How to Move WordPress Blog to New Domain or Location My Digital Life [...]
February 10th, 2009 00:48
I think 2 more queries should be added. Many people use additional fields to store queries for thumbnais and there is also info about attachents.
UPDATE wp_postmeta SET meta_value = replace(meta_value, ‘http://www.old-domain.com’, ‘http://www.new-domain.com’);
UPDATE wp_postmeta SET meta_value = replace(meta_value, ‘/home/old-domain/public_html’, ‘/home/new-domain/public_html’);
* This last one may depend on the host home directory and structure.
Long life wordpress!
Cheers, Alex from spain
February 8th, 2009 08:06
[...] Quelle: My Digital Life: How to Move WordPress Blog to New Domain. [...]
February 7th, 2009 08:44
Any one knows, what happens when the destiny domain is a IDN domain (forofundacionserranosuñer.es). I am having big problems and maybe this is why?
Thanks,
February 6th, 2009 21:31
hey,
You have said that “Note that this guide is not about how to move WordPress blog from one server or host to another new hosting service.” But if I want to do this how it is possible. If you have any solution please reply.
BR
moin
January 28th, 2009 16:19
[...] Kudos for this tip. This entry was written by Konstantinos Koukopoulos, posted on January 28, 2009 at 8:19 am, filed under memo and tagged domain, moving, mysql, sql, wordpress. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL. « Obama is left handed [...]
January 27th, 2009 11:20
Thank you very much. I’ve successfully move 2 blogs by referring to this tutorial. Thanx to the writer of this post.
January 26th, 2009 07:33
Thank you very much, following your directions helped me to make the migration without any trouble at all.
What surprised me most was that all my plugins worked right away as well! I was expecting trouble there, especially with NextGEN Gallery.
January 26th, 2009 03:33
Thanks!
January 24th, 2009 03:01
Hey this has helped me so much! Thanks!
January 24th, 2009 02:28
I tried to enter the code, but kept getting errors. what did i do wrong?
January 18th, 2009 20:04
ERay55 hi! how you doin?
January 16th, 2009 10:18
[...] di server yang lama. 3. Karena pindah nama domain maka jalankan perintah mysql berikut (dapet dari sini) [...]
January 16th, 2009 10:00
[...] di server yang lama. 3. Karena pindah nama domain maka jalankan perintah mysql berikut (dapet dari sini) [...]
January 11th, 2009 02:08
[...] (Fore future reference, if I had been interested in moving the blog to a new domain name entirely, I would also have followed the steps here or here). [...]
January 9th, 2009 07:27
[...] para ajustarlo a la url del sitio nuevo, pero me gaste un par de horas en google para encontrar que esta cosa requiere cambios a nivel de base de datos. Luego, mirando más en detalle, descubrí como wordpress guarda los datos, francamente llega a dar [...]
January 2nd, 2009 23:15
[...] [via MyDigitalLife] [...]
January 1st, 2009 02:45
Thank you very much!
December 7th, 2008 11:22
Could someone possibly interpert this info and lay it out a little more basic. The writer is on track but not very helpful on the step by step aspect for us more basic users. I know this is what I need to do but cant tell where to do some parts in the host or in wordpress.
December 5th, 2008 18:54
Thanks man. Everything is working again!
December 5th, 2008 14:29
It’s perfectly working!
Thanks a lot!
November 22nd, 2008 00:51
[...] How to Move WordPress Blog to New Domain or Location [...]
November 21st, 2008 02:45
Thank you very much! everything works perfectly.
November 15th, 2008 16:09
need some urgent help guys. my move from subfodler to root wen smoth, excet that now, evry page is extemely slow, even if I only browse through the backend
Ieven put the site in maintenance mod and deactivated all plugins and still as soon sI hit any page o this blog, cpu load goes to 80% nd the page comes down to a crawl. l other sites n thesame server are still actin normal.
ts leads me to th assumption that there are ome rdirects somewhere which are slowing it down. any hints what to check?
Except from the slowliness all is workin
November 15th, 2008 00:32
also one might have other places that mention the old url, so this plugin could also help: http://wordpress.org/extend/plugins/search-and-replace/faq/
November 15th, 2008 00:15
just moved my blog and this page saved my life.
but that was easy to figure out.
have to point out though, that I was not using the default table prefix
November 9th, 2008 12:12
You’re a rock star! Worked like a charm. Thanks a ton!
November 7th, 2008 21:37
I follow him to serve my turn upon him:we cannot all be masters, nor all masters.Cannot be truly follow’d.
October 26th, 2008 02:23
[...] your blog posts contain images or links using the old folder they must be changed. There is a simple SQL command which performs a search and replace. I suggest using phpMyAdmin instead of MySQL’s command [...]
October 20th, 2008 15:37
[...] of moving things as well. MyDigitalLife has written this excellent article, which tells you that how can you move WordPress blog to a new domain name. You just have to use this way [in this case the old domain will be http://localhost/ (in most of [...]
October 13th, 2008 02:51
very useful post – thanks. I saw mention of the plugin, but I prefer to do it this way, so that I can see what I am doing to the database.
October 10th, 2008 19:26
Great effort of providing latest Word Press information.
October 10th, 2008 12:22
Thank you! You’re a life saver!
October 6th, 2008 13:19
[...] 想读更详细的解释，请阅读How to Move WordPress Blog to New Domain or Location Written by admin in: Web Development | [...]
October 5th, 2008 01:53
Great post. We just released a plugin which simplifies this process for people who don’t want to, or don’t know how to, use phpMyAdmin.
All users need to do is upload the plugin and enter their old and new urls. Then presto, All links are updated!!!
Check out the Update URLs plugin here.
October 2nd, 2008 03:12
wow, thanks for the information..:)
September 30th, 2008 05:29
thanks for the great info i was having a blog of jokes
http://www.top-jokes.info where it was difficult to load and after making the changes you have listed above its been very easy for me to use the old website da\ta on my new domains.
thanks again.
September 28th, 2008 20:54
[...] …as per the instructions of this guy. [...]
September 21st, 2008 14:59
Thanx for that , its help me soooo much
September 20th, 2008 07:39
I have been using Joomla CMS since it’s beginning and really love it.
At the moment I am considering to use Wordpress as my blogging tool, and since this guide illustrates the easiness of the movement process, I am feeling a bit safer to convert
September 20th, 2008 06:10
My Favorit Blog. Very thanks and best regards from Germany. Thanks
September 17th, 2008 05:01
[...] moving wordpress site [...]
September 17th, 2008 00:37
[...] Mover un blog en Wordpress a otro dominio: “How to Move WordPress Blog to New Domain or Location“ [...]
September 16th, 2008 21:24
Just used your tutorial and it worked great! Thank you very much!
September 12th, 2008 04:34
[...] case of need, THIS can really helps ! This entry was written by Christophe, posted on September 11, 2008 at 10:34 [...]
September 10th, 2008 13:48
[...] バイトで必要になったので調べた。How to Move WordPress Blog to New Domain or Location » My Digital Lifeというエントリが参考になる。 [...]
September 9th, 2008 00:23
You just save my life! lol!
Thanks for your article.
It worked great! No fuzz!
August 24th, 2008 07:39
[...] database across, and after a few little changes here and there (wordpress plugins and a few little database changes) all was [...]
August 17th, 2008 10:38
[...] Once you have uploaded the posts to the new blog, you’ll also want to consider running the following 2 queries as suggested here: [...]
August 10th, 2008 05:26
great info
August 6th, 2008 18:00
[...] SQL codes from mydigitallife.info SHARETHIS.addEntry({ title: “How to move WordPress blog from old domain to new domain with 301 [...]
August 3rd, 2008 21:45
YOU TOTALLY SAVE MY LIFE!!!!!!!! THANK YOU SO SO SO VERY MUCH! Yea!
July 30th, 2008 15:56
Gold information.
You saved me hours.
Cheers
July 22nd, 2008 11:08
[...] http://www.mydigitallife.info/2007/10/01/how-to-move-wordpress-blog-to-new-domain-or-location/ [...]
July 14th, 2008 20:18
[...] I’ve posted this comment to the mydigitallife.info [...]
July 14th, 2008 20:04
Hi folks,
I had the same probs, butt I never knew on what it depend’s.
I changed the sites Url in the admin area of my Wordpress-blog, but that was an fault.
So nothing would be shown on the right place.
Therefor I needed to change it back, but there is no way to get in the admin area again logically, after I’ve changed the root Url.
So I opened my mind to get a solution. And just in this Moment it comes over me:
…only go on your hosting surface and start PHPmyADMIN and find the following database entry:
“Your WP-Blog database”–>wp_options–>make this database Entry editable–>now find the row “site_url”–>and change in the “options_value”column the root of your blog–>safe it and it’s done!
greetings, Simon
July 9th, 2008 13:38
yes there are open
http://www.demonoid.com/
July 1st, 2008 14:18
Thanks for that. When I googled for this topic another blog said , to this you have to backup the entire database, create new db and upload again. I was really tensed, but this was actually completed in seconds…..:)
June 26th, 2008 22:20
[...] the first thing to be done was to get hold of all the old posts (though very less in number). Here google served as a saviour and I got hold of a plugin called ‘wp-migrate‘, which let me export all the posts along [...]
June 19th, 2008 03:48
Thanks a lot for this tutorial! I’ve been wanting to do this for months but never dared because I was afraid of losing all my hard work. You really saved my day.
June 16th, 2008 08:30
Thanks so much for this post. It was tremendous help. That was so easy to follow and worked perfect.
June 15th, 2008 05:29
[...] all their sites to the new site. Some of these sites were wordpress powered. Thankfully, I found this article that made the move a [...]
June 14th, 2008 02:09
Thanks for this!
Everything working. Thanks for providing this valuable resource. Was invaluable for helping move our prototype Wordpress installation from my home server to full on hosting!
June 10th, 2008 00:26
I had no problem running the first query – the site found the home page instead of displaying a 404 error.
But whilst the second query executes (I am told 2 rows are affected) and when I click a link in the new domain site the correct url is shown in the address bar, all I get is a 404 Not found message saying the requested URL is not on the server – what does this suggest, have I lost some files?
June 9th, 2008 03:03
I just executed this command through PHPMyAdmin after dealing with 2 days of phantom redirects… turns out all that was wrong is I forgot to change the URL. This solved ALL my problems. You have no idea what a godsend this blog was to me. THANK YOU!
June 2nd, 2008 15:34
hi @ all i need plug in for hosting for wp who can help me
May 22nd, 2008 21:52
[...] url (siteurl) didn’t seem to help. More grumbling and puzzling around until I came across this post describing how which database values needed changing. Taking the advice of one of the comments this [...]
May 21st, 2008 20:56
[...] cambiar el de dominio o servidor a su blog en Wordpress estos son los tutoriales que utilicé: How to Move WordPress Blog to New Domain or Location y Changing The Site [...]
May 21st, 2008 08:12
An easier way to replace all occurrences of your old domain name is to export your database into a text file using phpmyadmin or a backup plugin, then use a text-code editor to find and replace all occurrences of olddomain.com with newdomain.com.
Import and voila!
May 21st, 2008 01:30
[...] Read full article on this link http://www.mydigitallife.info/2007/10/01/how-to-move-wordpress-blog-to-new-domain-or-location/ Tags: wordpress This entry was posted on Wednesday, May 21st, 2008 at 1:30 am and is filed [...]
May 16th, 2008 18:08
thanks for sharing this howto
May 10th, 2008 05:41
they had the wild playing still there. work visit little done it. let it go. reminded damage the forests
May 5th, 2008 20:26
[...] 1- Backup des données sur le serveur web 2- Backup de la base de données de l’ancien domaine (design.2803) 3- Création du dossier blogdecodesign.fr sur le serveur et de blogdecodesign.com avec une redirection 301 en htaccess vers le .fr 4- Upload de tout le dossier de l’ancien domaine vers le nouveau dossier (blogdecodesign.fr) 5- Création d’une nouvelle base de données 6- Upload de la base de données téléchargée au point 2 dans la nouvelle base de données 7- Exécution des lignes de commandes suivantes pour mettre à jour la base de données (source my digital life): [...]
May 1st, 2008 17:16
Thanks for sharing how to move WordPress blog to new domain or location.
April 28th, 2008 01:15
A really great help after moving my wp-installation. Made my day
Thanks
April 1st, 2008 03:21
Thanks for this article.
March 31st, 2008 13:53
this occured to me after moving from one webhost to another. i couldnt login as admin.
tried alot of the cheap fixes but the cheapest of all worked:
http://www.village-idiot.org/archives/2007/05/22/wp-emergency-password-recovery/
be sure to delete emergency.php after yer done!
March 27th, 2008 12:37
Hey again! Forgot to mention that I also had to change links to images inside post content!
Like this:
UPDATE wp_posts SET post_content = replace(post_content,”http://somedomain.com/newdir”,”http://somedomain.com/”);
The method is always the same, find the old link in the table fields and replace by the new one.
Bye!:)
March 27th, 2008 11:59
To fix images path after moving wordpress to another domain or directory you need to update wp_postmeta and wp_posts so that every link related to posts link to the new wp_content location. We need to do a find and replace in some tables of the database. Using phpMyAdmin You could use the following SQL code to search and replace de links.
UPDATE tablename SET tablefield = replace(tablefield,”findstring”,”replacestring”);
One example would be:
UPDATE wp_postmeta SET meta_value = replace(meta_value,”http://somedomain.com”,”http://somedomain.com/newdir”);
UPDATE wp_postmeta SET meta_value = replace(meta_value,”http://somedomain.com”,”http://somedomain.com/newdir”);
or the other way round depending on your case… (this was mine – changed to account root)
UPDATE wp_postmeta SET meta_value = replace(meta_value,”http://somedomain.com/newdir”,”http://somedomain.com”);
Note: You can use similar expressions to change links for “wp_posts” table, in this case the field to change is “guid”.
Note: In my case I had to Update Permalinks in Wordpress Admin->Options->Permalinks to update global linking.
IMPORTANT: Before changing any table fields look carefully at the field values of the tables in the database so you can decide what values to change.
This solved my migration of wordpress because after changing files to the server account root directory everything was pointing to the old URL.
Hope to help, I know what you guys are going through! I had this problem a few days ago.
Sorry if my English let You down but I’m just a poor Computer Engeneering Student from Portugal
Have a nice life! Peace!
March 18th, 2008 00:39
[...] to mydigitallife for the hints on how to do [...]
March 14th, 2008 15:40
i disabled all plugins, and the site worked again. maybe this helps. bye
March 14th, 2008 13:00
You rock and fixed my site. Gracias.
March 9th, 2008 15:54
These SQL statements made my day a lot easier. Thanks!
February 24th, 2008 00:23
hey, i followed these instructions, but wordpress now just wont display anything. i get a white page when opening index.php… anyway, i can display single pages with example http://url.com/wordpress/?p=123
strange is that i won’t find any php errors, httpd errors or anything alike. any suggestions?
samuel
February 19th, 2008 05:59
Thank you so much for the above instructions. You just saved me a lot of time! Much appreciated.
February 9th, 2008 10:14
[...] is to follow these instructions. I did. Result? All images became broken after the move. I followed these instructions to fix them in my SQL database. No luck. The results from the SQL queries stated that [...]
February 8th, 2008 12:13
[...] is to follow these instructions. I did. Result? All images became broken after the move. I followed these instructions to fix them in my SQL database. No [...]
January 22nd, 2008 07:24
THANKS!!! I thought I screwed things up royally by trying to organize my domain (and my life). This saved me.
Cheers
January 16th, 2008 01:20
[...] article en anglais chez MyDigitalLife explique également comment déplacer son blog WordPress. C’est une méthode très proche de [...]
January 14th, 2008 04:45
Thanks so much for this! I can’t believe this info isn’t on http://codex.wordpress.org/Moving_WordPress already! I’ve been suffering through all sorts of 404’s ever since following those instructions!
January 11th, 2008 04:48
What’s wrong with using the builtin Export-Import functions and then just install a plugin to redirect the URLs?
http://rmarsh.com/2006/09/23/moving-your-blog/