# Mautic Import stuck in progress

**URL:** <https://forum.mautic.org/t/mautic-import-stuck-in-progress/29945>\
**Category:** Product Support\
**Created:** [November 14, 2023, 5:13pm UTC](https://forum.mautic.org/t/mautic-import-stuck-in-progress/29945 "2023-11-14T17:13:30Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![iurijorbenadze](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/iurijorbenadze/32/12738_2.png) [@iurijorbenadze](https://forum.mautic.org/u/iurijorbenadze)\
**Post date:** [November 14, 2023, 5:13pm UTC](https://forum.mautic.org/t/mautic-import-stuck-in-progress/29945/1 "2023-11-14T17:13:31Z")

</div>

**Your software**  
My Mautic version is: 4.4.4  
My PHP version is: 7.4  
My Database type and version is: MariaDB

**Your problem**  
My problem is: In Mautic I can not import large files but I was able to import same size files before. (Small files are importing fine with no errors)

These errors are showing in the log:

Steps I have tried to fix the problem:  
I have increased MYSQL and MariaDB configurations that could have limited Megabytes or import time.

Also I have increased limits in php configurations, to be exact these changes have been made for php.ini:

/home/mydomain.com/domains/ems.mydomain.com/etc/php.ini

/home/mydomain.com/domains/ems.mydomain.com/etc/php7.4/php.ini

and I set values to:

memory\_limit=512M

upload\_max\_filesize=100M

post\_max\_size=128M

max\_execution\_time=7200

I get this error when importing:

ubuntu@mail:~$ sudo /usr/bin/php /home/mydomain.com/domains/ems.mydomain.com/public\_html/bin/console mautic:import  
Import 34 with 9501 rows is starting.  
2785/9501 [========\>-------------------] 29%  
In AbstractMySQLDriver.php line 112:

An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused

In Exception.php line 18:

SQLSTATE[HY000] [2002] Connection refused

In PDOConnection.php line 40:

SQLSTATE[HY000] [2002] Connection refused

mautic:import [-i|–id [ID]] [-l|–limit [LIMIT]] [-h|–help] [-q|–quiet] [-v|vv|vvv|–verbose] [-V|–version] [–ansi] [–no-ansi] [-n|–no-interaction] [-e|–env ENV] [–no-debug] [–]
