dongtang1944 2013-02-14 15:25
浏览 147
已采纳

MySQL数据库导出:允许的内存大小为67108864字节

First off, this issue has been stated on StackOverflow many times, but not where I am seeing the error. I've read through every one to make sure this is not a duplicate. Issue is occurring when I try to export a database from phpMyAdmin so that I can import it to another server. The .sql file is saving, but the last line shows the following error message.

Environment:

  • MediaTemple Grid Server (gs)
  • Wordpress plugin with MySQL database
  • Exporting using phpMyAdmin

Error message:

<b>Fatal error</b>: Allowed memory size of 67108864 bytes exhausted (tried to allocate 22505404 bytes) in <b>.../phpMyAdmin/current/libraries/export/sql.php</b> on line <b>1255</b><br />

PHP settings:

I have run the command: ini_set('memory_limit', '128M');, and phpinfo() shows memory_limit: 128M.

Everywhere that I have read, this is a PHP error. Could it have anything to do with MySQL variables?

Thanks in advance for your time and help!

  • 写回答

1条回答 默认 最新

  • drxv39706 2013-02-14 15:26
    关注

    No, it is most definitely a PHP error, probably stemming from a setting in PhpMyAdmin. Have you tried doing a mysqldump on the command line?

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 一个服务器已经有一个系统了如果用usb再装一个系统,原来的系统会被覆盖掉吗
  • ¥15 使用esm_msa1_t12_100M_UR50S蛋白质语言模型进行零样本预测时,终端显示出了sequence handled的进度条,但是并不出结果就自动终止回到命令提示行了是怎么回事:
  • ¥15 前置放大电路与功率放大电路相连放大倍数出现问题
  • ¥30 关于<main>标签页面跳转的问题
  • ¥80 部署运行web自动化项目
  • ¥15 腾讯云如何建立同一个项目中物模型之间的联系
  • ¥30 VMware 云桌面水印如何添加
  • ¥15 用ns3仿真出5G核心网网元
  • ¥15 matlab答疑 关于海上风电的爬坡事件检测
  • ¥88 python部署量化回测异常问题