search

Home  >  Q&A  >  body text

mysql - navicat 运行sql文件出现 out of memory

是想用运行sql来恢复数据库，但是一直是运行13秒左右显示err:out of memory 求解决方法

PHP中文网PHP中文网2784 days ago1277

reply all(3)I'll reply

  • PHP中文网

    PHP中文网2017-04-17 11:54:10

    The memory is not enough. It may be that an Insert carries too much data.

    Try using the mysql command line to restore

    reply
    0
  • 天蓬老师

    天蓬老师2017-04-17 11:54:10

    For large .sql files, you can directly use mysql to restore them,

    reply
    0
  • 巴扎黑

    巴扎黑2017-04-17 11:54:10

    官网论坛有解决方案
    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

    reply
    0
  • Cancelreply