NYCPHP Meetup

[Marc Antony Vose]

Hi there:

I'm on a shared machine, and trying to get some 15 MB or so SQL files  
into MySQL.  No problem doing this at the command line, of course, but  
I have several SQL files that need to be imported a few times a month.  
So, ideally, I'd like to FTP them to a directory and go to a web page  
and hit a button to do the import.

Problem is, the PHP script is terminating with a PHP error; server's  
support thinks it's out of memory.  According to phpinfo(), the script  
can use 90M, so the question is why a 20M sql import would use up 90M?

I'm doing it like this:

$cmd = "/path/to/mysql -h hostname -u username --password=password  
db_name < sqlfile.sql";
exec( $cmd );

I had thought that using this command-line command would prevent PHP  
from dealing with the memory footprint of the operation, but  
apparently this is not the case.

So...doable in PHP without an approach like busting apart the file  
into small chunks?  Or better to use another language on the server  
for this...?

Cheers,
Marc