DBSR: Database Search and Replace

DBSR version VERSION GUI

  1. Database connection information

    Database connection information

    Enter the connection details for the database server below.

  2. Search and replace options

    Search and replace options

    You have selected the database "DATABASE NAME" on DATABASE HOST:PORT. The connection will use the DATABASE CHARSET character set.

    Please enter the search and replaces values in the form below.

    Search for: Replace with:
    Note that all values are processed in order and thus may replace preceding values.

    When searching for a specific string it's sometimes useful to enter escaped sequences such as "\n" or \x5C".
    Checking the box below will make DBSR interpret all escaped sequences as PHP would in a double-quoted string.

    Case-insensitive search is disabled by default since most databases and filesystems are case-sensitive.
    Toggeling this settings might come in handy when running search-and-replace actions for user input.

    For performance reasons, DBSR normally only processes rows which contain one or more of the plain search strings.
    Checking the box below will make DBSR search through every field in the entire database, even if the search string does not occur in it.
    This may be useful when due to serialization the exact search strings do not occour in the database or when using DBSR to repair currupted serialized strings.
    Note: This makes DBSR a lot slower. In most cases, when there are no special characters in your search value, you shouldn't use this option.

  3. Confirmation

    Confirmation

    You selected the database "DATABASE NAME" on DATABASE HOST:PORT. The connection will use the DATABASE CHARSET character set.

    The following strings will be used for search-and-replace:

    Search for: Replace with:
    View as raw values, PHP escaped values or hex values
    RAW SEARCH VALUE RAW REPLACE VALUE
    ESCAPED SEARCH VALUE ESCAPED REPLACE VALUE
    HEX SEARCH VALUE HEX REPLACE VALUE

    It is highly recommended to make a backup of your database before using DBSR!
    If you haven't done so yet, do it now! Remember Murphy's law!

  4. Results

    Results

    RESULT occurence(s) found and replaced.