Re: Replication between different versions

2012-11-15 Thread Manuel Arostegui
2012/11/15 Lorenzo Milesi max...@ufficyo.com Hi. Is it possible to have a master/master replication between servers of different versions? Now I've two 5.0.51 syncing themselves. I'm installing a new server with 5.5.28 and I'd like if I can upgrade but still mantaining compatibility.

Re: Replication between different versions

2012-11-15 Thread Reindl Harald
Am 15.11.2012 12:46, schrieb Manuel Arostegui: 2012/11/15 Lorenzo Milesi max...@ufficyo.com Hi. Is it possible to have a master/master replication between servers of different versions? Now I've two 5.0.51 syncing themselves. I'm installing a new server with 5.5.28 and I'd like if I can

Re: Issue regarding the import of the date from csv file to the table in the database in mysql

2012-11-15 Thread hsv
2012/11/15 00:30 +0100, Mogens Melander I guess I'm sill learning. Does that mean that, if the last column in a load blabla. is a -00-00 terminated by ^n it might error ? Or are we talking ODBC ? Find it under LOAD DATA If an empty field is parsed for a NOT NULL DATE or DATETIME,

Re: query tuning

2012-11-15 Thread James W. McNeely
Rick, This is incredibly useful, thanks for taking the time to share with me. I am really learning stuff here! Thanks, Jim On Nov 14, 2012, at 5:12 PM, Rick James wrote: A PRIMARY KEY is a KEY, so the second of these is redundant: PRIMARY KEY (`zzk`), KEY `zzk` (`zzk`), Compound

RE: query tuning

2012-11-15 Thread Iñigo Medina
Good advices indeed. Thanks for sharing. iñ On Wed, 14 Nov 2012, Rick James wrote: A PRIMARY KEY is a KEY, so the second of these is redundant: PRIMARY KEY (`zzk`), KEY `zzk` (`zzk`), Compound indexes are your friend. Learn from http://mysql.rjweb.org/doc.php/index1