On 11/5/10 9:57 AM, Wellington Fan wrote:
I think the "-t" flag to mysqldump dumps just the data, and not the schema.
this might be useful in ensuring that you don't accidentally change the schema with your
sed.
Right, but the point of testing against the schema file is so that you
ensure you'
I think the "-t" flag to mysqldump dumps just the data, and not the schema.
this might be useful in ensuring that you don't accidentally change the schema
with your sed.
--
wellington
___
New York PHP Users Group Community Talk Mailing List
http://lis
You could also do a mysqldump, find and replace with sed, then import.
--Original Message--
From: Dan Cech
Sender: talk-boun...@lists.nyphp.org
To: talk@lists.nyphp.org
ReplyTo: NYPHP Talk
Subject: Re: [nyphp-talk] Searching an Entire MySQL Database
Sent: Nov 4, 2010 09:29
On 11/4/2010
And, make a backup.
Michele
From: Andrew Yochum
Sent: Thursday, November 04, 2010 11:00 AM
To: NYPHP Talk
Cc: NYPHP Talk
Subject: Re: [nyphp-talk] Searching an Entire MySQL Database
On Nov 4, 2010, at 9:41 AM, Rob Marscher wrote:
On 11/4/2010 08:32, p...@blu-studio.com wrote
On Nov 4, 2010, at 9:41 AM, Rob Marscher wrote:
>> 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 en
> 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) t
On 11/4/2010 8:32 AM, 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.
The simplest way will be to loop through the tables in php (use SHOW
TABLES),
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/
On Thursday, November 4, 2010, Michael Southwell
wrote:
> 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 e
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 rep
On Thursday, November 4, 2010, 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.
I'm having a hard time imagining a practical application of this, or
even how it co
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.I am open to here about any or most effective method: Is there a unique MySQL query techniqueA SQL query that can do this? A SQL quer
12 matches
Mail list logo
