NYCPHP Meetup

[Michael Southwell]

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

Feasible only if the db is not gigantic and you can afford to have it 
down momentarily

-- 
=================
Michael Southwell
Vice President, Education
NYPHP TRAINING:  http://nyphp.com/Training/Indepth