WampServer

hello peeps.

I have a small problem and i really don't have a clue as to what is causing this.
now i have my website running, but i've noticed that whenever i download a file from it, it's corrupted.
any file above 700KB.
Now i've been on joomla and even remository forum but i didn't get a solid answer so here i am.

1)is there like a limit of file size to upload that phpmyadmin can handle ?

and

2) in phpmyadmin, why when i import, it says file size 2,048kb, what if my db is bigger than that ?

let me know if you need more info as this is a serious problem

Hi,

phpMyAdmin must be reading the PHP settings from the php.ini file from C:\wamp\bin\apache\apache2.2.8\bin where you can find the followind lines:

; Maximum allowed size for uploaded files.
upload_max_filesize = 2M

You can increase the size, but there are a couple of other settings that are involved, like:

max_execution_time = 30 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
memory_limit = 128M ; Maximum amount of memory a script may consume (128M

; Maximum size of POST data that PHP will accept.
post_max_size = 8M

Each of these settings needs to have high enough value for the file upload to succeed. You can read a good summary from [www.radinks.com].

One could also install for example the FileZilla server and use an FTP client to upload files.

Regards,

toivo
Sydney, Australia

toivo Wrote:
-------------------------------------------------------
> Hi,
>
> phpMyAdmin must be reading the PHP settings from
> the php.ini file from
> C:\wamp\bin\apache\apache2.2.8\bin where you can
> find the followind lines:
>
> ; Maximum allowed size for uploaded files.
> upload_max_filesize = 2M
>
> You can increase the size, but there are a couple
> of other settings that are involved, like:
>
> max_execution_time = 30 ; Maximum execution
> time of each script, in seconds
> max_input_time = 60 ; Maximum amount of time each
> script may spend parsing request data
> memory_limit = 128M ; Maximum amount of
> memory a script may consume (128M
>
> ; Maximum size of POST data that PHP will accept.
> post_max_size = 8M
>
> Each of these settings needs to have high enough
> value for the file upload to succeed. You can
> read a good summary from
> [www.radinks.com].
>
> One could also install for example the FileZilla
> server and use an FTP client to upload files.
>
> Regards,


ok mate, thanks for that link but since the default is 2mb in phpmyadmin, why are my files corrupted after download ? the one that corrupts are the only ones that 1+mb in size. on my site i have only 2 files that is 1.15mb that is all, they are not bigger than 2 so i don't think i should mess around with phpyadmin settings for now.. what do u think can do this ?

again many thanks

The limitation of 2MB comes from PHP, which gets its settings from the php.ini file. Therefore the upload limitation is not affecting just phpMyAdmin, but all uploads supported by PHP applications in the server.

If you adjust the settings from the previous message to higher values, then restart Apache or All services, your uploads should work better. I know downloads which are several hundred MB work all right, but we tend to use FTP to upload them.

Regards,

toivo
Sydney, Australia

toivo Wrote:
-------------------------------------------------------
> The limitation of 2MB comes from PHP, which gets
> its settings from the php.ini file. Therefore the
> upload limitation is not affecting just
> phpMyAdmin, but all uploads supported by PHP
> applications in the server.
>
> If you adjust the settings from the previous
> message to higher values, then restart Apache or
> All services, your uploads should work better. I
> know downloads which are several hundred MB work
> all right, but we tend to use FTP to upload them.
>
> Regards,


ok mate i adjusted some values in the php.ini, i was able to download the file at home, but in the office i still can't , it corrupts, someone on Joomla forums told me maybe it's something to do with firewall on the webserver, anyways i will check, many thanks !!!

If you have error messages in your PHP error log about failed transfers or AcceptEx, PHP sessions run out of memory and Apache restarts, you should include the following directives in httpd.conf:

EnableMMAP off
EnableSendfile off
Win32DisableAcceptEx


More info:

[httpd.apache.org]
[httpd.apache.org]
[httpd.apache.org]


Regards,
Toivo

toivo
Sydney, Australia