无法从PHP脚本执行mysqldump（大数据）

Question

I'm trying to make a database dump from my php script, when I only try to dump the database structure it works just fine, but when I try to dump the data the application crashes, I tried using the options : --opt and --quick, but that didn't work for me. Any ideas ?

Answer 1

Run this before your script:

ini_set('memory_limit', '-1');

You may also need this line to make sure PHP doesn't time out:

set_time_limit(0);