How to Perform a Search and Replace on a WordPress Website

This video tutorial gives an overview of the process using the Search and Replace plugin to search and replace text in your WordPress database. Why would you need this? One main reason is if you change the domain name of your WordPress website. The old domain name will exist in many places in the database including on posts, pages, and in several other tables.

If you find my tutorials useful, please rate, stumble, or otherwise share on your preferred social network. If you would like to be part of an exclusive community and receive specialized WordPress training, please visit http://adamwwarner.com to learn more.

---

Closed Caption:

hello again everybody this is Adam
I am in the midst
love movin my installation from Word
Press mater .org
to WP mater dot com and
in that process I have got the
basic insulation done I've imported
the the the XML
export from WordPress matter in to
the WP matter dot com you can
see that all my posts have imported one
thing you'll notice is that on the
sidebar
I've got the default widgets layout from
the a default theme
and I do not have the
widgets that I normally have on were
pressed
modern at work but that's okay because
frankly I think it's scanner
ugly looking and it's time for change
anyway so
this video is a
to show you a one-step in this process
just to make sure that all my internal
links are working
and that will be the installation and
usage
up the search and replace plugin so I'm
gonna go down to plug ins here
I'm going to click at noon I'm going to
search for the search and replace plugin
in and there it is
and then this sir plugin layout as a
little bit different
and 3.0 I've noticed a its has a details
and install now
some gonna go ahead and click Install
Now
and that seems to instead of having to
click through to the details and then
click Install it looks like they've
taken one
step out on the processor so that's a
good usability in my mind
the shortest path to the goal the better
a something to go ahead and activate the
search to replace
plugin I've never used this before by
the way so
this is all brand new to me looks like
it comes down here in the tools area
I'm gonna go ahead and click search and
replace and
the let's see here okay so it
uses a standard sequel query where for
those who don't know that's
Structured Query Language that's the
language used to interact with your
database
so I use as a standard single query in
you can do any
and do any changes make a backup of the
database
this is where back up buddy who would
come in handy
but because this is brand new I'm not
going to worry about that for now
because I can just reduced us here for
things go wrong I are so let's see it
looks like it gives me
choices over what to search in so I'm
gonna go ahead and search
in everything I'm going to check all
in the content the GUID
titles ex-servicemen air talent sick
cetera et cetera
some gonna go ahead and search for
or
Press honored or
and I'm going to replace it with WP
matter
dot com okay
and here we go here goes nothin okay
attempting to perform surgery place
working in looking in
and looks like there were quite a lot so
and posts post content there were 44
entries him 126 in the GUID
or quid not quite sure how that's
pronounced someone please leave a
comment in
school me on there a
see post meta and Manor values forty
five entries
so in the comments a cursory 216
entries found: so I'd say it's pretty
good thing I did that
so let's just double check we've got
everything
and do the search again and this time
there should be
no results one entry
okay
so that is the search and replace plugin
as used in partovi domain name
move hope that was helpful