Проэкспериментировав полдня, я добился того, что phpMyAdmin изменил свое отношение ко мне и выдал нечто иное:
Ошибка
Кажется возникла ошибка в Вашем SQL запросе. Описание ошибки от MySQL сервера дано ниже, возможно, оно поможет Вам разобраться
ERROR: Неизвестная строка с пунктуацией @ 390
STR: ://
SQL: products_id,products_ean,products_quantity,products_shippingtime,products_model,group_ids,products_sort,products_image,products_price,products_discount_allowed,products_date_added,products_last_modified,products_date_available,products_weight,products_status,products_tax_class_id,product_template,options_template,manufacturers_id,products_ordered,products_fsk18
185,"",0,0,cd1,"","",http://www.a2zcds.com/productpics/img173.jpg,199.500,0.00,"","","",0.00,1,1,default,default,1,0,0
186,"",0,0,cd2,"","",http://www.a2zcds.com/productpics/img174.jpg,199.500,0.00,"","","",0.00,1,1,default,default,1,0,0
187,"",0,0,cd3,"","",http://www.a2zcds.com/productpics/img175.jpg,149.500,0.00,"","","",0.00,1,1,default,default,1,0,0
...
612,"",0,0,cd428,"","",http://www.a2zcds.com/ProductPics/img610.jpg,399.500,0.00,"","","",0.00,1,1,default,default,1,0,0
613,"",0,0,cd429,"","",http://www.a2zcds.com/ProductPics/img611.jpg,149.500,0.00,"","","",0.00,1,1,default,default,1,0,0
SQL-запрос :
products_id,products_ean,products_quantity,products_shippingtime,products_model,group_ids,products_sort,products_image,products_price,products_discount_allowed,products_date_added,products_last_modified,products_date_available,products_weight,products_status,products_tax_class_id,product_template,options_template,manufacturers_id,products_ordered,products_fsk18 185,"",0,0,cd1,"","",http://www.a2zcds.com/productpics/img173.jpg,199.500,0.00,"","","",0.00,1,1,default,default,1,0,0 186,"",0,0,cd2,"","",http://www.a2zcds.com/productpics/img174.jpg,199.500,0.00,"","","",0.00,1,1,default,default,1,0,0 187,"",0,0,cd3,"","",http://www.a2zcds.com/productpics/img175.jpg,149.500,0.00,"","","",0.00,1,1,default,default,1,0,0
...
611,"",0,0,cd427,"","",http://www.a2zcds.com/ProductPics/img609.jpg,399.500,0.00,"","","",0.00,1,1,default,default,1,0,0 612,"",0,0,cd428,"","",http://www.a2zcds.com/ProductPics/img610.jpg,399.500,0.00,"","","",0.00,1,1,default,default,1,0,0 613,"",0,0,cd429,"","",http://www.a2zcds.com/ProductPics/img611.jpg,149.500,0.00,"","","",0.00,1,1,default,default,1,0,0
Ответ MySQL:
#1064 - 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 'products_id,products_ean,products_quantity,products_shippingtim
Оказалось, что MS Excel при "сохранить как... CSV (разделители - запятые)", вместо запятых вставляет ";". Еще я вставил ("") во все пустые столбцы, а также заменил на ("") все значения "NULL", правда не знаю, нужно ли было это делать.
Номер ошибки остался тот же, но MyAdmin мне что-то новое говорит в начале, чего я не понимаю. Может быть в кавычки должно быть взято все, что стоит между запятыми? Если это так, то тут я не знаю как это сделать, Excel это не делает, а файл большой, вручную - застрелиться.