Upload Large files to MYSQL

Titans

Hi guys

The page cannot be displayed ...... Sounds Fimiliar ?

I've read almost all the Posts on Uploading large files (Flat File/ Mysql) But Still...
All the settings in php.ini is modified

post_max_size 20M
upload_max_filesize 15M
memory_limit 30M
max_execution_time 0 (unlimited)
file_uploads 1

But still 😕

and the Server is on my LAN .. Redhat Linux box Brand New..

What Else can it Be ??

:mad: :mad: Help

Kudose

That doesnt really tell me what the problem is. What size is the file you are trying to upload?

rheinen

If you are using Internet Explorer (as it sounds like you might be by the generic 'Page Cannot Be Displayed' message) you may be able to get a more specific error message by turning off friendly HTTP error messages. (Tools -> Internet Options..., Advanced Tab, and then uncheck "Show friendly HTTP error messages" under the Browsing section).

Other than that it might be helpful to see relevant parts of your form and PHP code and to know the size of the file you are trying to upload.

A long shot but did you restart the server after making the changes to php.ini? You may want to double check that the settings are working properly by examining the output of phpinfo().

Ryan

bretticus

Trying to import a huge file to a MySQL database server the other day via phpMyAdmin, I had the same issue. Being lazy and not wanting to type out the query in a shell prompt (which seems kinda silly now as I could have copied the query out of phpMyAdmin), I uploaded the file to /tmp via FTP and then ran my query (because Apache will have a limit to the size of the upload file as well.) It crashed on me until I cranked up to 40MB via

ini_set("memory_limit","40M");

. So if you don't have shell access, you may have to look for a program to break your text file up and do it piece-by-piece. If you do, I would suggest using mysql from shell prompt and uploading the file to /tmp or another convenient path on the database server.

Oh...and do as Ryan says so you can evenbe certain what the error message is that Apache/PHP returns.

Titans

Hi Guys

Yes Any Files larger than say 500 Kb

I've turned off friendly HTTP errors this is what it comes up with..

Request Entity Too Large ...
... does not allow request data with POST requests, or the amount of data provided in the request exceeds the capacity limit.

Also tried bretticus' code - still nothing

"cranked" it up to 100 MB in php.ini - Still no fun...

But.. Wait

If You edit the /etc/httpd/conf.d/php.conf

<Files *.php>
SetOutputFilter PHP
SetInputFilter PHP

Max Attachment Size : 521 Kbytes

LimitRequestBody size: 524288
</Files>

Set it up to approx 10485760 (+- 10 MB I think)
and Bob's ur uncle..

bretticus

Also tried bretticus' code - still nothing

You tried my code but you did not heed my advice. When you have gargantuan SQL file(s) to upload, you'll save yourself a headache by uploading to /tmp and using mysql command from shell.

Titans

bretticus wrote:
You tried my code but you did not heed my advice. When you have gargantuan SQL file(s) to upload, you'll save yourself a headache by uploading to /tmp and using mysql command from shell.

No, tried : ini_set("memory_limit","40M");

But Like you said, in the end I would have to first move to a temp file, and then to database...

At this moment my MYSQL Server has "gone away" to where i don't know.. :-)

Error Message "MySQL server has gone away"

While I'm out looking for it think i'll grab a cup of tea at the

Restaurant at the end of the Universe

Titans

Figured it out...

Add this entry to /etc/my.cnf (mysql's config file)

[mysqld]
set-variable = max_allowed_packet=20M

for more info go to http://mysqld.active-venture.com/Option_files.html

If there's a easier way Feel Free !!
I'll start working on bretticus' plan next..