i will look at this type of solution. thanks. peter
-------- Original Message --------
Subject: Re: [nyphp-talk] Searching an Entire MySQL Database
From: Michael Southwell <michael.southw...@nyphp.com>
Date: Thu, November 04, 2010 6:11 am
To: NYPHP Talk <talk@lists.nyphp.org>
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
_______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk
http://www.nyphp.org/Show-Participation
