PHPMyAdmin 怎么导入大SQL文件

eshuqian

400M以上的SQL文件，压缩成zip后导入也说太大，怎么进行导入？

catding

标记一下

信仰

eshuqian 发表于 2012-12-13 18:04
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 133696552 bytes) ...

DZ的?DZ自带不是有备份功能，备份成2M的 全部通过FTP下载到本地然后上传到空间导入

samro

标记

feixiang

分割，推荐一个非常小的程序。
比帝国备份王小很多。

http://www.softpure.com/html/show_details/57.htm

eshuqian

wzwen 发表于 2012-12-11 09:58
400M感觉不应该再用虚拟主机了

本来是在VPS，但程序是 康盛的早期版本，且对多个产品做过大量二次开发而导致无法升级
已知程序应该有漏洞，被放过Shell且原因不明，就不太敢放VPS上，怕影响其他网站。

看样子这能单独给它个VPS了

eshuqian

信仰 发表于 2012-12-11 11:43
http://www.kokgog.com/thread-153698-1-2.html
http://www.kokgog.com/thread-153701-1-2.html
试试这两 ...

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 133696552 bytes) in
http://***.com/down/import.php

此方案 Over

joyanhui

Captain 发表于 2012-12-11 00:05
如果是只能phpmyadmin，打开phpMyAdmin目录下的配置文件：config.inc.php

请注意其中的这两个参数：

很给力！

eshuqian

malsvent 发表于 2012-12-11 06:10
http://faq.1and1.com/web_space__access/mysql/13.html
可以import和export
我试过在fatcow上export过600M ...

Stopped at the line 427.
At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts or very long procedure definitions. Please read the BigDump usage notes for more infos. Ask for our support services in order to handle dump files containing extended inserts.
Stopped on error

此方案 Over

eshuqian

Captain 发表于 2012-12-11 00:05
如果是只能phpmyadmin，打开phpMyAdmin目录下的配置文件：config.inc.php

请注意其中的这两个参数：

虚拟主机修改不了配置文件，此方案 Over