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

Question

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?

Please post the complete content of your Mysql.php content so we can see what is on your line 169. — Wilson Hauck, Commented 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. — Wilson Hauck, Commented Mar 10, 2019 at 12:23

vmp · Accepted Answer · 2018-12-17 09:37:04Z

0

There could be a couple of possible reasons for this.

The database user account used or the table name is incorrect.
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)
The source and destination database must be on the same SQL server.

answered Dec 17, 2018 at 9:37

vmp

3984 silver badges17 bronze badges

Add a comment |

1 Answer 1