Import Excel CSV issue in MySQL

Question

Hello Expert,

I have Azure Database for MySQL flexible server with Burstable, B1ms, 1 vCores, 2 GiB RAM, 20 GiB storage and connected to MySQL. However when I import excel data using Table Import Data Wizard, it taking so long to complete even though it has only 800 rows (200kb). I also realize that not all rows are imported, only 46 rows were successfully imported.

I did test to import the same excel file to my local server in mysql, all was imported without issue and very quick. What is wrong? Is there any limitation of size in Azure?

Thanks Expert.

Answer 1

Hi Andrew •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you are unable to import excel data using Table Import Data Wizard which is taking long, and not complete data imported.

This seems strange and should not happen. Could you please let us know if you have checked all network or connectivity aspects of your server?

If not, we recommend you to check and retry.

Refer https://learn.microsoft.com/en-us/azure/mysql/single-server/how-to-troubleshoot-connectivity-issues

https://learn.microsoft.com/en-us/azure/mysql/single-server/how-to-troubleshoot-common-errors

If this does not help, please let us know for further investigation.

Thanks.