Skip to navigation | Skip to content



Archive for the category ‘databases’

Moving WordPress to a new domain or server

moving-wordpress

WARNING! This post isn’t really for beginners. In any case, please back all your stuff up comprehensively before trying anything out. If you don’t know what you’re doing, things could go quite wrong.

NOTE: I’ve not tested it yet, but check out the WordPress Move plugin – could help if anyone needs something a little more user-friendly than the process documented below (although knowing what’s going on behind the scenes can only help!).

This post has been translated into French by Jean-Guy Grenot.

Moving WordPress’s location—be it to a new domain, a new server location, or both—has never been as easy as it might be. Here I’m going to document my own process for achieving this, and try to keep it updated with new ideas and lessons learned.

Please note before starting that I’m concentrating here on the WordPress-specific side of this process. For anything not related to WordPress regarding moving domain or server, you should probably check with your domain registration service or web hosting provider.

Read more »

phpMyAdmin global search & replace

I can’t believe I’ve been so stupid.

It’s a regular job for me: I’ve developed a WordPress-driven site on a subdomain, and I need to shift it to the live domain. Export the database as an SQL file, recreate it on the new server and / or domain. Then zip through and replace all instances of the development domain with the live domain.

Not too bad if there’s not much to replace. But I’m just moving a site at a relatively late stage of development and manual replacing was too much. How to do a global search / replace in phpMyAdmin?

The answer is, you don’t. When you’ve exported the database as an SQL file, open the file up in a good text editor and search / replace there. Then import the new file.

Simple.

View complete archives »