Snoyes: that’s a.

 
Bachinski: Jww: the ch****t being used to store the data must match the connection ch****t and client ch****t

Deglandon: Bachinski: I miss the default-character-set directive on the destination server.

Terrall: It’s set to utf8 for mysqldump and mysqlserver on the source server.

Bachinski: Jww: any reference to connection ch****t or client ch****t that isn’t matched?

Lacatena: No I can’t find anything like that.

Stezzi: I found that a character é was replaced by ‘%C3%A9’ , but not all é

Bachinski: Jww: show variables like ‘character_set_%’; — look for default connection ch****t

Dicola: Those characters set are differents !

Budden: On the origin it’s all utf8 , but on the new it’s latin1 for character_set_database and character_set_server

Bachinski: Jww: those defaults are used if there is no ch****t defined at lower levels. no column definition, uses the table definition, no table definition, use the database definition, etc upwards

Nobbe: I see. so it’s not my problem.

Vollenweider: I mean it’s not related.

Bachinski: Jww: well, using the mysql cli client to import utf8 across a connection ch****t of latin1 can be a problem

Bachinski: Jww: does the dumpfile include a statement to SET NAMES utf8? that will set the client and connection to utf8

Bachinski: Jww: of course we’re ***uming the data coming out of the source was correctly stored in the first place :-

Labay: Bachinski: no there is no SET NAMES in my current dump, trough I’ve seen it while doing tests.

Stidman: For each table I see : /*!40101 SET character_set_client = utf8 */;

Murri: I have a very weird suspicion that MySQL avg is giving me wrong result. Could it be possible?

Marohl: Here’s my query & data: https://gist.github.com/ankurkaushal/d97ad7ab71775bd409a6

Bachinski: Jww: be nice to use a my.cnf config setting to require utf8 connection setting and do the import over

Mccalop: My.cnf settings are no substitute for SET NAMES

Klier: Hi, can i ask here about MySQL API?

Rolseth: I have a list of values, i want to insert the ones that does not already exist in the table.

Jamel: Is there any elegant way to do that?

Moretz: Insert them all into a temporary table, and then use:

Piano: Halvors: SELECT a.* FROM a LEFT JOIN b ON a.id = b.id WHERE b.id IS NULL;

Vanderwood: Alternatively, put a unique constraint on the table, and use INSERT IGNORE.

Narayanan: Snoyes: You mean INSERT INTO . SELECT a.* FROM a LEFT JOIN b ON a.id = b.id WHERE b.id IS NULL;

Brennen: Bachinski: ok I got /*!40101 SET NAMES utf8 */; in the dump file now, I try to restore it.

Milionis: Halvors: yes, something along those lines

Zutell: I’m struggling wit the version text at the end.

Cornely: Mango_: why not use mysql -v?

Leas: Bachinski: nah there is still the same problem :

Leilich: Snoyes: I need to log into the server.

Ralon: Typically you’d put the query part inside quotes

Ottenwess: Mysql -e “show variables like ‘version'”

Somers: I imagine you need the same, maybe with some escaping

Balmaceda: Yes I did try, let me check again.

Schwertfeger: Does Nelles allow off-topic conversation?

Bachinski: Jww: well, are you exporting corrupted data?

Cumpston: Snoyes: double quotes didn’t work, escaping is needed I think

Gheza: Mysql -e “show variables. perhaps

Orta: Bachinski: I see no others options

Gidwani: Relipse: I think you just did

Sevigny: Bachinski: I suspect this since I found the %3C%A9 , it’s some mysql collate stuff I googled about it

Butte: Snoyes: that’s a Niedzwiedzki error.