Hello johan
Here is what did the trick for me:
1. in mysql-inst1, I created like table called test.user
2. I used mysqldump to pipe test.user table from mysql-inst1 to mysql-inst2
3. in mysql-inst2, I did insert into mysql.user select from test.user
We are migrating from master-slave
2012/03/16 13:30 -0400, Simon Wilkinson
My query for this is as follows: select * from table where table.date1 -
table.date2 between 28425600 and 29030400;
I would not count on that subtraction s yielding a meaningful number: the types
are not Unix timestamps. I would use TIMESTAMPDIFF, with a
