Hi Marc:
On Wed, Oct 21, 2009 at 06:48:13PM -0400, Daniel Convissor wrote:
>
> By saying the log shows "premature end of script headers," I assume
> you're talking about Apache's error log, right? What does PHP's error
> log show? See the log_errors and error_log settings in php.ini to learn
I think the post about the command line maybe the way to go. People suck
into terabytes of sql files into mysql tables. At that level you want to go
hardcore and get as close to raw inputs as possible.
The command line and VI are your friends. Really! :-) That's about as
hardcore as you can go.
I remember seeing "Premature end of script headers" with
Perl scripts when I mistakenly ftp'd them to the server in binary
mode instead of ascii mode. Drove me crazy, and I knew better
than to do that, I just overlooked the mode when I uploaded.
Glenn
On Oct 21, 2009, at 6:48 PM, Daniel Conviss
Hi Marc:
> Sorry...I made a typo there. I meant that the script is terminating
> with a 500 Error (NOT a PHP error)...which means there is no log or
> useful error trail. All I see in the error_log is the dreaded
> "Premature end of script headers" error.
By saying the log shows "prematu
Le Oct 21, 2009 à 9:08 PM, Damion Hankejh a écrit :
Sounds familiar to an issue I had with uninformative 500 Internal
Server errors -- my script was timing out. Check your max script
execution time with:
echo ini_get('max_execution_time');
Extend it with:
set_time_limit($seconds); // ha
Re: [nyphp-talk] using PHP to import large-ish SQL into mysql
Sounds familiar to an issue I had with uninformative 500 Internal Server
errors -- my script was timing out. Check your max script execution time
with:
echo ini_get('max_execution_time');
Extend it with:
s
Sounds familiar to an issue I had with uninformative 500 Internal Server
errors -- my script was timing out. Check your max script execution time
with:
echo ini_get('max_execution_time');
Extend it with:
set_time_limit($seconds); // has no effect if running safe_mode
---
Damion Hankejh | hanke
Le Oct 21, 2009 à 8:11 AM, Daniel Convissor a écrit :
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 po
Hola:
On Tue, Oct 20, 2009 at 08:14:23PM -0400, Jake McGraw wrote:
> Modify your insert statements to take advantage of LOAD DATA INFILE:
Definitely a handy statement. But you'll need to be granted "FILE"
permissions (aka "File_priv") in MySQL, which is not enabled by default.
And the input f
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
wrote:
> Hi Marc:
>
> FYI, in the future, when starting a new topic, make a who
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
If you are getting an "out of memory" error from a PHP program, see if
on your shared hosting account you have access to the php.ini file. If
so, increase the memory.
After you locate the php.ini file, look for this line:
memory_limit = 16M ; Maximum amount of memory a script may consume
Th
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
13 matches
Mail list logo
