DBSR: Database Search and Replace

Database connection information

Enter the connection details for the database server below.

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.

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.
Interpret PHP escaped sequences.

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.
Case-insensitive search.

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.
Run an extended search.

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:

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!

Yes, I have read the warnings above and checked that the search and replaces values are correct.

Results

RESULT occurence(s) found and replaced.

Delete DBSR from the web server.