# I would like to ask if any one knows how I can solve this error that come while I was importing the data

**URL:** <https://forum.shopware.com/t/i-would-like-to-ask-if-any-one-knows-how-i-can-solve-this-error-that-come-while-i-was-importing-the-data/101274>\
**Category:** International (English Only)\
**Created:** [18. September 2023 um 07:12 UTC](https://forum.shopware.com/t/i-would-like-to-ask-if-any-one-knows-how-i-can-solve-this-error-that-come-while-i-was-importing-the-data/101274 "2023-09-18T07:12:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![PatrickDane](https://avatars.discourse-cdn.com/v4/letter/p/ba9def/32.png) [@PatrickDane](https://forum.shopware.com/u/PatrickDane)\
**Post date:** [18. September 2023 um 07:12 UTC](https://forum.shopware.com/t/i-would-like-to-ask-if-any-one-knows-how-i-can-solve-this-error-that-come-while-i-was-importing-the-data/101274/1 "2023-09-18T07:12:00Z")

</div>

It comes when I was running the cron: /opt/plesk/php/8.2/bin/php -d memory\_limit=8G bin/console sw:cron:run Shopware\_CronJob\_XMLget -f

An exception occurred while executing ‚UPDATE s\_crontab SET action = ?, `interval` = ?, data = ?, active = ?, next = ?, start = ?, end = ?, disable\_on\_error = ?, name = ? WHERE id = ?‘ with params [„Shopware\_CronJob\_XMLget“, 3600, „a:1:{s:5:"error";s:63:"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away";}“, „0“, „2023-09-17 11:58:17“, „2023-09-17 09:32:12“, „2023-09-17 10:57:59“, „0“, „XML Get“, 31]:

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away  
Please use the action name of a cronjob. You can see existing cronjobs in shopware backend or via sw:cron:list command.

---

<div class="post-metadata">

**Author:** ![Max\_Shop](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Max\_Shop](https://forum.shopware.com/u/Max_Shop)\
**Post date:** [18. September 2023 um 07:52 UTC](https://forum.shopware.com/t/i-would-like-to-ask-if-any-one-knows-how-i-can-solve-this-error-that-come-while-i-was-importing-the-data/101274/2 "2023-09-18T07:52:19Z")

</div>

> [@PatrickDane](#):
>
> 2006 MySQL server has gone away

Your MySQL Server had too much data to handle and thus „crashed“. Try to increase the memory limit für MySQL or reduce the PHP memory\_limit, that it is available for MySQL.

Maybe try to reduce the import file by splitting it into several files and import it one by one.