Modify your insert statements to take advantage of LOAD DATA INFILE: http://dev.mysql.com/doc/refman/5.1/en/load-data.html
You should see a perf improvement. - jake On Tue, Oct 20, 2009 at 8:11 PM, Daniel Convissor <dani...@analysisandsolutions.com> wrote: > Hi Marc: > > FYI, in the future, when starting a new topic, make a whole new email, so > it doesn't look like it's part of the thread you're replying to. Now to > your question... > > >> Problem is, the PHP script is terminating with a PHP error; server's >> support thinks it's out of memory. > > Why should anyone be guessing what the issue is? PHP's error messages > explain exactly what the problem is in plain English. Please post the > actual error message. > > >> $cmd = "/path/to/mysql -h hostname -u username --password=password >> db_name < sqlfile.sql"; >> exec( $cmd ); > > Yeah, that shouldn't involve PHP's memory. > > Another thought, if this is (nearly) all you're doing, why involvine PHP > at all? Do it directly in a shell script. > > import.cgi > --------- > #! /bin/sh > > /path/to/mysql -h hostname -u username --password=password \ > db_name < sqlfile.sql > --------- > > --Dan > > -- > T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y > data intensive web and database programming > http://www.AnalysisAndSolutions.com/ > 4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409 > _______________________________________________ > New York PHP Users Group Community Talk Mailing List > http://lists.nyphp.org/mailman/listinfo/talk > > http://www.nyphp.org/Show-Participation > _______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
