将42MB .sql文件导入WAMP

Question

I have tried every suggestion I can find without success...edited the php.ini file in WAMP, tried bigdump, tried command line and I cannot import a Magento v1.9 .sql db file in WAMP (latest version).

The .sql is good, because I can import into my live server magento test site without a problem, but it fails every time I try to load to my localhost WAMP setup.

Any help greatly appreciated...

Answer 1

Few options : Open php.ini file :

Locate : post_max_size = 750M
Locate : upload_max_filesize = 750M
Locate : max_execution_time = 5000
Locate : max_input_time = 5000
Locate : memory_limit = 1000M

Restart Wampt.

Compress the database, it would decrease the size to a large extent. You can even import Zipped files : i.e abc.sql.zip Or abc.sql.gz