Re: Data transfer

["Ananda Kumar" <anandkl@xxxxxxxxx>]

does your development server have only one database or multiple database.

regards
anandkl


On 4/11/08, Krishna Chandra Prajapati <prajapatikc@xxxxxxxxx> 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
>