Bonjour,

j'ai un souci avec l'importation d'une toute petite base (22 Mo) sur une machine Vista et uniquement sur cette machine vista (wamp5)

La même base, initialement sauvegardée sur une gentoo, est correctement restaurée sur un xp (WAMP5), sur une ubuntu (LAMP de base).
Sur ces machines sont également restaurées régulièrement des bases de 3 Go sans aucun souci

Voic les messages d'erreurs que j'ai une première fois

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Script line: 2399	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '',NULL,1,0,1,0),(37,56663,'29.12.37','Compresseurs volumétriques rotatifs',NULL' at line 1
Script line: 2400	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL,1,0,1,0),(65,72576,'54-17-228','Médis',NULL,1,0,1,0),(65,72577,'54-17-229'' at line 1
Script line: 2401	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,0,1,0),(65,101354,'11-78-644','Verrière',NULL,1,0,1,0),(65,101355,'11-78-645'' at line 1
Script line: 2402	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','L\'ISLE D\'ESPAGNAC\r',NULL,1,0,1,0),(1,15484,'32300','L\'ISLE DE NOE\r',NULL' at line 1
Script line: 2403	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,0),(1,28910,'91400','SACLAY\r',NULL,1,0,1,0),(1,28911,'02200','SACONIN ET BREU' at line 1
Script line: 2636	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '63,61598,64),(60612,62,61599,64),(60838,63,61599,64),(60612,62,61600,64),(60838,' at line 1
Script line: 2637	Column count doesn't match value count at row 39367
Script line: 2639	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '65),(61017,63,93446,65),(60663,62,93447,65),(63731,64,93447,65),(61016,63,93447,' at line 1
Script line: 3009	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'B9C61E92180A9A557A1B70458AA2A30AE56C0F924C9A08454867918EFC3877F706E5E2D193D54E0E' at line 1
Script line: 3011	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '362F5769647468735B32333320302030203020302030203738372035303420302030203020302030' at line 1
Script line: 3284	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '101',1),(10000030,10001704,'bbb_102',1),(10000030,10001705,'bbb_103',1),(1000003' at line 1
Script line: 3311	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Actif','',120131,0),(10001627,'Inactif','',120131,0),(10001628,'Portée','',1201' at line 1
Script line: 5188	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','_graal_ove_acteurs_interlos_01.php',0,0,0,0,4,'aam'),(10000365,'Div_00152','_' at line 1
Script line: 5214	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'des demandes de prix (modèle 3 désignation seule sans notion de valeur ni de q' at line 1
une deuxième fois

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
Script line: 2399	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '26.24','Produits céramiques à usage technique et services associés',NULL,1,0,' at line 1
Script line: 2400	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '54-17-258','Neuillac',NULL,1,0,1,0),(65,72607,'54-17-259','Neulles',NULL,1,0,1,0' at line 1
Script line: 2401	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '),(65,93064,'31-62-074','Bailleulval',NULL,1,0,1,0),(65,93065,'31-62-075','Bainc' at line 1
Script line: 2402	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHATEAUROUX\r',NULL,1,0,1,0),(1,7306,'44690','CHATEAUTHEBAUD\r',NULL,1,0,1,0),(1' at line 1
Script line: 2403	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '16270','ROUMAZIERES\r',NULL,1,0,1,0),(1,28660,'16270','ROUMAZIERES LOUBERT\r',NU' at line 1
Script line: 2636	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '63,66611,65),(60602,62,66612,65),(61275,64,66612,65),(60808,63,66612,65),(60602,' at line 1
Script line: 2637	Column count doesn't match value count at row 16398
Script line: 2639	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '03785,65),(64682,64,103785,65),(61101,63,103785,65),(60686,62,103786,65),(64679,' at line 1
Script line: 3259	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,1,1,0,0,0,0,NULL),(10002258,10001001,1,1,0,0,0,0,NULL),(10002259,10001002,1,1,' at line 1
Script line: 3284	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '47,'aau_100',1),(10000087,10000048,'aau_101',1),(10000087,10000049,'aau_102',1),' at line 1
Script line: 3311	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Critères','',120131,0),(10001752,'Valeur','',120131,0),(10001753,'Position','',' at line 1
On note que que cela ne plante pas au même endroit !!!

Petite précision : là où cela fonctionne, dans le my.ini, le default-character-set=utf8 alors que sur vista il est latin1

Mais si je le passe en utf8, alors là, c'est la cata ... impossibilité de créer certaines tables et donc là, tout part en vrille ...

D'avance, merci pour vos pistes. Je suis bien planté et j'ai besoin d'exploiter cette base dans un environnement Vista.