NYCPHP Meetup

[Christopher R. Merlo]

On Thursday, November 4, 2010, Michael Southwell
<michael.southwell at nyphp.com> wrote:
> On 11/4/2010 08:32, ps at blu-studio.com wrote:
>
> I am wondering if anyone has had to search an entire database and do a
> search and replace on a string. That is to search in every table, in
> every row, in every field.
>
>
> export the entire database into a file
> use PHP (or a good editor) to make the replacement line by line
> drop the database
> re-create it by importing the modified file

This is potentially very dangerous, because you can inadvertently
change column names, table names, etc.