Hi

Is there any PHP script(open source) to retreive the queries from the MYSQL log files.My exact requirement is i want synchronise databases on two diffrent host.What i am planning is to read the queries from the log files of one database and execute the queries the same in the database in another host.But i find MYSQL generating log file of the form

Host-bin.212
212: is an id which keeps incrementing whenever a new log file is created(new file being created daily)

But i am not able to read this file.

Can anyone of u give me an suggetion

Hello,

that may help:
http://www.phpbuilder.com/columns/ta...u20000912.php3

py

p.s. You should not use the log files to acheive what you want.