CODEWITHSUNDEEP
phpmysqldatabasedump
teeyo
teeyo

Reputation: 3755

Can't do a mysqldump from a PHP Script (Big data)

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 ?

Upvotes: 0

Views: 107

Answers (2)

Manoj Sonagra
Manoj Sonagra

Reputation: 45

You may need to increase the execution time of your application. From the code:

ini_set('max_execution_time', 3000);

Alternatively, you can edit the max_execution_time field in your php.ini file.

Upvotes: 0

Dany Caissy
Dany Caissy

Reputation: 3206

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);

Upvotes: 1

Related Questions