On 11/4/2010 08:32, p...@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
_______________________________________________
New York PHP Users Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
http://www.nyphp.org/Show-Participation
