是想用运行sql来恢复数据库，但是一直是运行13秒左右显示err:out of memory 求解决方法
认证高级PHP讲师
The memory is not enough. It may be that an Insert carries too much data.
Try using the mysql command line to restore
For large .sql files, you can directly use mysql to restore them,
官网论坛有解决方案We recommend to use the Execute SQL File feature to run long sql. Right-click the opened connection and choose Execute SQL File from the popup menu.
https://community.navicat.com/forum/navicat-product/navicat-premium/107-out-of-memory-error-in-running-sql
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
The memory is not enough. It may be that an Insert carries too much data.
Try using the mysql command line to restore
For large .sql files, you can directly use mysql to restore them,
官网论坛有解决方案
We recommend to use the Execute SQL File feature to run long sql. Right-click the opened connection and choose Execute SQL File from the popup menu.
https://community.navicat.com/forum/navicat-product/navicat-premium/107-out-of-memory-error-in-running-sql