Which tables should be selected?

  • Resolved artisanseo

    (@artisanseo)


    8 years, 4 months ago

    hi,

    this is a very powerful (somewhat scary powerful) plugin. 😉

    just wondering how safe it is to select all tables – for those of us who aren’t developers/coders?

    for example, i’m using tokens on local sites (5-10 pages) that are cloned

    searching for the state abbreviation “ST” i get –
    “DRY RUN: 40 tables were searched, 117 cells were found that need to be updated, and 0 changes were made.”
    With –
    wp_wfLogins 49
    wp_wfStatus 43

    seems excessive, unless they are logged results?…

    any input appreciated

    thanks

    https://wordpress.org/plugins/better-search-replace/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Matt Shaw

    (@mattshaw)

    8 years, 4 months ago

    Hi,

    From a technical standpoint it’s safe – the plugin was designed to handle being run on all tables with different types of data.

    But it is important to have the correct search string, for example it’s safer to replace URLs on all tables than it is for a short string like “ST”. With a URL, you can be sure that the URL will be the only thing to be replaced. With “ST”, that could be the only thing that gets replaced, or it could make up a part of another word.

    That said, a bad search string ran on all tables could definitely cause damage to the database. That’s why it’s really important to have a recent backup of the database and run a dry run before running a search replace.

    I’m marking this as resolved, but please let me know if you have any other questions. Thanks!

    Thread Starter artisanseo

    (@artisanseo)

    8 years, 4 months ago

    hi matt,

    thanks for the speedy reply.

    i did backup and am hoping that using uppercase for all my tokens (and the fact it does do case-sensitive operations) will prove to be wise, but… maybe i’ll do one more backup before the next operation – just in case…;)

    great plugin!

    thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Which tables should be selected?’ is closed to new replies.