How to fix the migration error How to fix the migration error [Exception] Warning: PDOStatement::execute(): MySQL server has gone away in

C:\xampp7.0\htdocs\magento220\vendor\magento\data-migration-tool\src\Migration\ResourceModel\Adapter\Mysql.php on line 169. 

I don't know how to find out this error? Could you please help me?

  • Hi @Amit Bera, could you please help me? Dec 17, 2018 at 8:27
  • Please post the complete content of your Mysql.php content so we can see what is on your line 169. Dec 25, 2018 at 18:52
  • If you have resolved this situation, please let us know how. if the Answer helped, please Upvote/Accept to credit vmp for sharing his knowledge. Mar 10, 2019 at 12:23

1 Answer 1


There could be a couple of possible reasons for this.

  1. The database user account used or the table name is incorrect.
  2. the user account used does not have the correct privileges to execute the queries. (Read for the source database and read/write for the destination database)
  3. The source and destination database must be on the same SQL server.

read this for more information: https://devdocs.magento.com/guides/v2.3/migration/migration-tool-configure.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.