MySQL Bugs: #106780: MySQL not uploading all records from CSV file.

Bug #106780	MySQL not uploading all records from CSV file.
Submitted:	18 Mar 2022 15:49	Modified:	21 Mar 2022 17:01
Reporter:	lala sd	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	8.0.28	OS:	Windows (Microsoft Windows 10 Enterprise)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\I33326\AppData\Roaming\MySQL\Workbench\log\wb.log]

i am trying to upload CSV in workbench through table import wizard however it uploads only 30 records out of 10k.

This is the dataset csv file : https://drive.google.com/file/d/1n7nq98D6bFaPdWq1SuieG8cAO3fW6sc1/view

How to repeat:
it repets every time i try to upload and happens with every dataset, day before yesterday it wasnt happening.

Hi Mr. sd,

Thank you for your bug report.

First of all, we suppose that you have used MySQL Workbench, so the problem might be related to it.

Second, we need a test case. Hence, we need a CSV file, exact table(s) definition and exact commands for uploading the rows. All with all necessary details.

We are waiting on your feedback.

CSV file i am using (zomato)

Attachment: zomato.csv (application/vnd.ms-excel, text), 2.02 MiB.

hi sir

i have attached CSV file. however since day before yesterday, this is happening with every single CSV file  i upload. i have uploaded 500k rows csv file it took 12 hours but all rows were imported. but NOW when i upload any csv file it only take some amount of rows. regardless of csv file size or record. 

please check the issue

i have searched ALL OVER INTERNET. not single answer i found please help. i have upcomong sql interview

Hi Mr. sd,

We have analysed your report and we concluded that it is a duplicate of the following bug report:

https://bugs.mysql.com/bug.php?id=97813

Duplicate.

you guys are really doodoo, go and check yourself if your duplicate big has solution provided by you.

shame on you Oracle dammn i just cant understand you guys just labeling as duplicate instead of providing solution i am switching on microsoft sql
shitty product sql u have 

by the the duplicate u said dont have any solution in there