WP-CLI doesn't replace sitename

Question

I am trying replace the site url via WP-CLI the command bellow:

wp search-replace "https://oldUrl" "http://newUrl" --allow-root --all-tables --verbose

However I am getting in the console:

+----------------------------------------+-------------------------+--------------+------+
| Table                                  | Column                  | Replacements | Type |
+----------------------------------------+-------------------------+--------------+------+
| wp_post                                |                         | skipped      |      |
| wp_user                                |                         | skipped      |      |
| wp_postmeta                            |                         | skipped      |      |
| wp_usermeta                            |                         | skipped      |      |
| .........                              |                         | skipped      |      |

What I missed?

That looks correct. Is your old site `https`? Try doing the search-replace without the HTTP protocol `//oldUrl` `//newUrl` — disinfor, Apr 21 '21 at 14:39
@disinfor I tried without the HTTP protocol, unfortunately not working — Dmitry Leiko, Apr 21 '21 at 15:01
Found this: https://kellenmace.com/wp-cli-search-replace-tables-skipped/ Might be useful in your case. Good luck! — disinfor, Apr 21 '21 at 15:03

score 1 · Accepted Answer · answered Apr 21 '21 at 15:49

1

I found the solution. One of the keys in each database table has to be marked as the primary key, or else WP-CLI will skip over it and output skipped as shown above. Thanks @disinfor very help me. Always to check the tables in database.

answered Apr 21 '21 at 15:49

Dmitry Leiko

3,970
3
25
42

WP-CLI doesn't replace sitename

1 Answers1