HI Option 1
If you are using PHP, you can do this very simply using CRON task. Make a field for to update either your first operation is successful (eg. Update the field value to 1 ). Run a CRON job in particular interval if the field updated as 1 then call your second operation query and make the field value 0. Option 2 If you are using MySql 5.0. check the trigger examples to perform the on update ... And follow the same idea like update a field value 1 and write a trigger for upate. I hope this will give you idea. Thanks & regards, Muthukumar Selvarasu, Project Manager (Web Development), Webmasters Ltd. -----Original Message----- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Friday, April 11, 2008 6:59 PM To: mysql; [EMAIL PROTECTED] Subject: Data transfer Hi, What ever queries are executed on 5 mysql server with multiple database (more than one database on each mysql server). I have to reflect all the changes on 1 mysql server (developement server for developers) Initially, I thought to take take the queries from bin-log and execute on development server. But, from the bin-log list. I am not able to identify that which queries belong to which database. Content of bin-log (multiple database) # at 266708750 #080410 4:04:27 server id 1 end_log_pos 148 Query thread_id=460143 exec_time=0 error_code=0 SET TIMESTAMP=1207825467; UPDATE user_time_stamp_1 SET TIME_TOTAL='-999' WHERE USER_ID='8394042' AND TASK='2.30'; # at 266708898 #080410 4:04:27 server id 1 end_log_pos 266708925 Xid = 22953623 COMMIT; # at 266708925 #080410 4:04:27 server id 1 end_log_pos 162 Query thread_id=460143 exec_time=0 error_code=0 SET TIMESTAMP=1207825467; UPDATE user_cookie SET VALUE = '2.30_1207830154' WHERE USER_ID = '8394042' AND PARAM = 'CURRENTTASK'; # at 266709087 #080410 4:04:27 server id 1 end_log_pos 266709114 Xid = 22953624 COMMIT; What are the possible ways to perform this task. --Thanks, Krishna Chandra Prajapati -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
