WP-CLI doesn't replace sitename

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?

1 answer

  • answered 2021-04-21 15:49 Dmitry

    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.