wp-cli search-replace command not searching and replacing

Question

I'm using wp-cli tool for searching and replacing the site's url to a new url. I'm executing this command in command line in the directory of the wordpress installation:

C:\xampp\htdocs\somewebsite>wp search-replace 'somewebsite.com' 'new_website.com'

the command does not issue any errors, and when i check the database with this sql:

SELECT * FROM wp_options WHERE option_value LIKE '%new_website.com%'

I get zero results.

I have the the username, password, db name, location set correctly in wp.config file.

EDIT

By any chance does this have to do with the sql file permissions?

EDIT Ok it wp-cli did not work for me but https://interconnectit.com/products/search-and-replace-for-wordpress-databases/ did. Make sure you use the stable version as of this writing which is: v2.1.0 STABLE.

Ok it wp-cli did not work for me but https://interconnectit.com/products/search-and-replace-for-wordpress-databases/ did. Make sure you use the stable version as of this writing which is: v2.1.0 STABLE. — dave, Sep 19 '15 at 01:36
possible duplicate of [MySQL search and replace syntax error](http://stackoverflow.com/questions/32592208/mysql-search-and-replace-syntax-error) — galfaro, Sep 19 '15 at 14:24
Was it a really big db? I am running into this with a dump file that is around 150 mb. — Jake, Jul 25 '17 at 19:22

score 11 · Answer 1 · answered Feb 12 '16 at 14:55

11

I just had the same issue, and the problem was single quotes in the Windows command prompt - the following worked for me:

wp search-replace "somewebsite.com" "new_website.com"

answered Feb 12 '16 at 14:55

avy

644
6
16

OMG, spent an hour searching what's wrong... – pacmanito Jan 07 '22 at 13:23
BINGO. Confirmed cuplrit. In windows cmd, using " (double quotes) instead of ' (single quotes) made all the difference. – TARKUS Jun 16 '23 at 15:40

score 0 · Answer 2 · answered Sep 19 '15 at 00:34

0

Your syntax looks correct. Try adding --verbose to the end of your search-replace command and check the output. All wp-cli search-replace options can be found here: http://wp-cli.org/commands/search-replace/

answered Sep 19 '15 at 00:34

Andy

46
4

k i tried adding --debug: wp search-replace 'somewebsite.com' 'new_website.com' --debug, and still same results. – dave Sep 19 '15 at 00:36
by any chance does this have to do with the sql file permissions? – dave Sep 19 '15 at 00:38
--verbose did not print anything, just goes back to new line in command prompt – dave Sep 19 '15 at 00:39

score 0 · Answer 3 · answered Oct 26 '16 at 07:54

You need to check your wp-config.php thoroughly. For me I was loading wp-settings.php twice which is the reason why there was no output at all because there were errors behind the scenes. You need to set define('WP_DEBUG', true); to see the errors and you can start fixing your wp-config.php from there.

score 0 · Answer 4 · answered Jan 03 '17 at 19:13

I ran into a similar problem a while ago. As it turned out, I did not have the current wp-cli version installed. I was typing correct syntax, but the command was not executing, and no errors were returned.

wp cli check-update

wp cli update

after I updated to version 1.0 I no longer had any problems.

Just a thought.

wp-cli search-replace command not searching and replacing

4 Answers4