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

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

[27 May 2025 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 2025 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 2025 15:52] muppala vinisree

the data is in tabled which is of extension csv

[27 May 2025 15:53] muppala vinisree

please fix it as early as possible

[28 May 2025 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