Development server has multiple databases. On Fri, Apr 11, 2008 at 3:07 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> does your development server have only one database or multiple database. > > regards > anandkl > > > On 4/11/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > > > 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 > > > >
