PHP Script to retrieve queries from log file
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
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