Re: enhanced search and replace

From: Joshua Kugler <joshua.kugler@uaf.edu>
Date: Wed Feb 23 2005 - 21:26:52 AKST

Why not add the fields to the table, then drop them after importing the dump?

j----- k-----

On Wednesday 23 February 2005 19:49, Clay Scott wrote:
> i've got a mysql dump file from an app i'm helping on, but the author added
> three new fields to one of the tables in the latest release. now the dump
> file i generated won't import because mysql complains that the number of
> fields doesn't match that of the dump file (32 fields in the table, the
> dump file has 29). so i'm trying to come up with a quick command to parse
> the .sql file, search for the lines that start with INSERT INTO <table>
> VALUES blah and replace the ); on the end of the line with ,'','',''); so
> it thinks the three new fields are represented, but blank.
>
> i'd do it by hand if there weren't about 5000 entries to be modified. i was
> going to just split the lines for this table out since four tables are
> represented in the dump file, but this is something i'd like to know....
> that and i'm slightly regex-retarded.
>
> thanks,
> ~clay
>
> ---------
> To unsubscribe, send email to <aklug-request@aklug.org>
> with 'unsubscribe' in the message body.

-- 
Joshua Kugler
CDE System Administrator
http://distance.uaf.edu/
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
Received on Wed Feb 23 21:26:49 2005

This archive was generated by hypermail 2.1.8 : Wed Feb 23 2005 - 21:26:49 AKST