Posted by Raj Shekhar on 08/29/05 07:11

Robin Vickery <robinv@gmail.com> writes:

> On 8/23/05, Jay Blanchard <jay.blanchard@niicommunications.com> wrote:
> > You may (or may not) remember me posting to the list a couple of weeks
> > ago asking about using REGEX to get queries out of PHP files for a
> > migration project. I had to let it go for several days, but started
> > working on it again yesterday, here is the code (no REGEX was used in
> > the making of this code);
>
> Just a thought - and I know it's a little late, sorry.
>
> Have you considered writing a wrapper for mysql_query() that logs its
> parameters?

(I cannot locate the original post, hence replying to this mail)

You can enable logging in mysql server itself to log all queries
http://dev.mysql.com/doc/mysql/en/binary-log.html ( there are ways to
restrict logging to only some databases) . Later when you want to replay
the sql statements, you can use mysqlbinlog

--
Raj Shekhar
blog : http://rajshekhar.net/blog home : http://rajshekhar.net
Disclaimer : http://rajshekhar.net/disclaimer

• Next in forum: Issue with generating asx playlist with php
• Prev in forum: guidance for communicating between frames
• Thread view: Re: Getting queries from files FYI

[Reply to this message]