Haxby: Venezia: when I migrate the mysal tables am I supposed to overwrite the existing data in them?
Tynan: TheMineBench: Hint, it involves GROUP BY.
Prinkey: Xgc: the primary key is accountId, clientId so there can’t be multiple clientIds with the same account
Kaumo: TheMineBench: The table called “last5” does.
Venezia: Scott0_: just bring over the whole db directory
Dumar: Venezia: moving from 32bit to 64 also
Vandergraph: TheMineBench: I’m asking you to ***ume you have that table.
Simkulet: TheMineBench: I have a reason.
Starch: TheMineBench: There’s a method to my madness.
Decoux: Scott0_: why can’t you?
Der: The 32 bit files won’t work on 64bit will they?
Malatesta: Xgc: No I don’t know. I could probably find out in one google search x
Ufford: I was under the impression they won’t
Whitfield: TheMineBench: The table called “last5” contains the result of your last query to find the last 5 logins for that account.
Potratz: TheMineBench: Try google.
Decoux: Scott0_: who told you about that?
Venezia: Scott0_: the files aren’t affected by that
Piccirilli: TheMineBench: Once you have that, I can show you a little trick to create that table in your query.
Decoux: Scott0_: I think you need to forget what you “hear”.
Venezia: Is this why you wanted to use a new server instead of an upgrade? someone might just be trying to sell you a bridge :
Mino: I did read it somewhere
Decoux: Venezia: a golden bridge
Browing: So the innodb files can just be moved over?
Fleeger: TheMineBench: Btw, your attempt to find the last 5 logins was not correct.
Decoux: Scott0_: yes, yes, yes, yes yes yes yes and yes
Szafranski: Ok that changes some things
Guise: I was looking forward to building the binlog with the dump
Venezia: Scott0_: make sure the db is shut down first if you just move the files. if you need it running, use a hot tool like xtrabackup to move them
Lyday: TheMineBench: find them with SELECT COUNT* as qty,dupefield,otherfields FROM table GROUP BY dupefield,otherfields HAVING qty 1
Hearson: I was hoping to enable the binlog for future replication
Elis: Which I can’t do if I just move the files
Nicholas: Xgc: SELECT clientId FROM last5 GROUP BY clientId HAVING COUNT* 1;?
Decoux: Scott0_: you need to record the binlog position if the new server is a slave.
Kozar: The new server is the master
Denholm: TheMineBench: Correct. Now before we continue, you need to correct your attempt to find the last 5 logins.
Decoux: Scott0_: stop the current master save the current binlog position. Move the datadir / my.cnf over to the new master, enable binlogs on the new master. Set up the old master as a slave using the binlog position you recorded.
Tocher: Xgc: I forgot the DESC?
Nunery: TheMineBench: That’s all
Mccadden: Http://pastie.org/private/ow2fxy9upywwbtlyrsyl4a anybody?
Drinski: I’m trying to replicate from a MySQL master in to a node of an XtraDb cluster.
Ruedy: Nothing in error log at time of issuing commands
Skradski: TheMineBench: Now review this. See the first query. It uses a construct called a “derived table”. http://sqlfiddle.com/#!9/4d13d/2
Mortel: TheMineBench: You can apply your your logic to find duplicates to that derived table.
Legault: TheMineBench: See this slight change, for clarity: http://sqlfiddle.com/#!9/4d13d/3
Kynard: TheMineBench: You can take the . AS last5 and drop that directly into your duplicate query, replacing the base table last5.
Sessums: TheMineBench . You’re welcome.