Support » Developing with WordPress » wp search-replace skipped tables

  • When using the following wp-cli command, I’m seeing some tables are “skipped” (primarily the core tables) while others are processed without issue.

    INPUT
    wp search-replace 'http://mysite.com' 'http://mysite.dev' --all-tables --dry-run

    OUTPUT

    | ms_links     | link_notes              | 0            | SQL  |
    | ms_links     | link_rss                | 0            | SQL  |
    | ms_options   |                         | skipped      |
    | ms_postmeta  |                         | skipped      |
    | ms_posts     |                         | skipped      |

    Also, I noticed that wp_options does not have option_id set to AUTO_INCREMENT and thus there are hundreds of rows with 0 as the ID.

    I don’t know if these two issues are related and was wondering if anyone has seen anything like this before (and if so, what the cause/fix was).

    Thanks in advance.

    Ted Stresen-Reuter

Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘wp search-replace skipped tables’ is closed to new replies.