List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 17 2003 11:43pm
Subject:Re: forcing mysql binlog to a single line
View as plain text  
At 16:30 -0700 4/17/03, Jeremy Zawodny wrote:
>On Mon, Apr 14, 2003 at 10:10:11AM -0700, Mark wrote:
>>  Hi, does anyone know of a way to force mysql to log update queries as
>>  single line queries even if they are multiline queries?
>
>You can't do that, no.
>
>>  the reason is it would be easier to grep through them to restore a
>>  single table
>
>You might consider using a short Perl script, taking advantage of
>Perl's flexible input record separator.  It doesn't have to be "\n",
>that's just the default.

The mysql_find_rows script included with MySQL might prove of
some assistance here.

>
>Jeremy
>--
>Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
><Jeremy@stripped>  |  http://jeremy.zawodny.com/
>
>MySQL 4.0.8: up 73 days, processed 2,378,935,555 queries (374/sec. avg)


-- 
Paul DuBois
http://www.kitebird.com/
sql, query
Thread
forcing mysql binlog to a single lineMark14 Apr
  • Re: forcing mysql binlog to a single lineJeremy Zawodny18 Apr
    • Re: forcing mysql binlog to a single linePaul DuBois18 Apr