PHPMyAdmin 怎么导入大SQL文件

dakai

楼主，看这里http://1024.me/import-6-millions-logs-text-file-to-mysql/
本人的博客

誓誓

学习了

mmdmm

帝国备份王

伦敦的夜

帝国备份王，2G无压力。

cuxian

帝国备份王  4G都无压力

eshuqian

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

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

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

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

joyanhui

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

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

很给力！

eshuqian

信仰 发表于 2012-12-11 11:43
http://hostloc.wiki/thread-153698-1-2.html
http://hostloc.wiki/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

eshuqian

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

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

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