Bug #118274 Only partial data imported when uploading large Excel file

• Submitted: 27 May 2:07
• Modified: 28 May 12:20
• Reporter: muppala vinisree
• Status: Duplicate
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 8.0.42
• OS: Any
• CPU Architecture: Any

[27 May 2:07] muppala vinisree

Description:
When importing large Excel files (e.g., with more than 50,000 rows), the application imports only a portion of the data (e.g., first 10,000–20,000 rows), and silently skips the remaining rows without any error or warning.
The upload process shows success, but the data in the system is incomplete.
This issue does not occur with smaller Excel files.

How to repeat:
Open the application.

Go to the "Import Data" section.

Choose a large Excel file (e.g., 50,000+ rows).

Click “Import.”

Check the database or view the imported data — only partial data is present.

[27 May 7:57] MySQL Verification Team

Hello muppala vinisree,

Thank you for the bug report.
Is it CSV file or SQL file? Please provide sample data to reproduce this issue at our end.

Regards,
Ashwini Patil

[27 May 15:52] muppala vinisree

the data is in tabled which is of extension csv

[27 May 15:53] muppala vinisree

please fix it as early as possible

[28 May 12:20] MySQL Verification Team

Hello muppala vinisree,

Thank you for the details.
Imho this is duplicate of Bug #97813, please see Bug #97813.

Regards,
Ashwini Patil