Search results do not correspond to reality in database

  • Ambyomoron

    (@josiah-s-carberry)


    7 years, 3 months ago

    In testing this plugin, I do a dry run to determine which tables might be affected and how many times in each table. When I look directly in the database, I do not find the same number of cases in the tables. For example, I search for https://www.xzy.com. the plugin tells me it occurs 6 times in wp_postmeta. I then look in that table using phppmyadmin. In fact, it occurs only 2 times.
    What’s going on? Why this difference?

Viewing 4 replies - 1 through 4 (of 4 total)

  • Same problem here. there should be a preview to verify

    I did a dry run using better search and replace to go from http to https
    I got 238 cells or instances of
    https://domain.com being replaced with https://domain.com .

    To compare:
    When I tried using migrate DB plugin by the same company with a search and replace
    of the above domain and exported the db to an sql file and did a find for
    https://domain.com in the file showed 706 cells! I know one of them is a comment, but something doesn’t look correct.

    ???? I have used migrate db (plugins by the same company) many times and know lots of people who use it and this is a very large discrepancy between this and better search and replace plugin.

    Thanks!

    No answers? Bad sign!

    ok. I get it for some of this. What is going on is that these are the rows not the cells. A cell in a row can contain many instances. However, I’m still getting weird results for the options table. in better search and replace after running it 2 times I got two different values: 1st 28 and then 31 rows!? Then is search and replace plugin I got 31 and then in the interconnect script I get 21. So, that is a little concerning.
    The postmeta and posts tables have the same number of rows.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Search results do not correspond to reality in database’ is closed to new replies.