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 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)