Max File Upload Size My SQL

SQL, file size, upload, easyphp

[JayDev]

Hi,

I have been searching the web and searching webmasterworld to figure out how to increase the file size for uploads to My_SQL when importing a file.

I am using EasyPhp1.7 which uses phpmyadmin. I did find some information which seemed detailed online talking about updating the php.ini and my.ini files for the following function:

upload_max_filesize = 100M

for the php.ini and

set-variable = max_allowed_packet=100M

which was originally set to 2M as default.

I updated the files, exited Apache and restarted it. Still nothing when trying to upload a large file.

Here are the files that I have within easyphp:

/php/php.ini-dist
/php/php.ini-recommended
/safe/http-sage
/safe/php-safe
/safe/my-safe

The folder /phpmyadmin does not include any of the file names above.

I spent hours on this and have run out of options. Maybe someone who knows exactly what he/she is doing can shed some light.
I would really appreciate it.

Thanks,

[edited by: JayDev at 9:44 pm (utc) on Sep. 16, 2006]

[ahmedtheking]

Hmmm, how big is the file? Since it's SQL (I'm guessing that), have you tried GZipping it?

[JayDev]

Yes, I tried to zip a file but since it is already pretty large b/w 50 to 100M, the file still gets to be much larger than 2M.

The file is csv, not SQL. I also tried a SQL file without success.

The only alternative is to go into the file and make chunks of 2M. If you have a file of +100M, do the math!

[finnyfin]

did you write this script? if not, have you checked to see if there is some sort of maxsize variable in the code?

[eelixduppy]

Also check post_max_size [php.net] in your php.ini

post_max_size integer

Sets max size of post data allowed. This setting also affects file upload. To upload large files, this value must be larger than upload_max_filesize [php.net].

If memory limit is enabled by your configure script, memory_limit [php.net] also affects file uploading. Generally speaking, memory_limit should be larger than post_max_size.

When an integer is used, the value is measured in bytes. You may also use shorthand notation as described in this FAQ.

If the size of post data is greater than post_max_size, the $_POST and $_FILES superglobals are empty. This can be tracked in various ways, e.g. by passing the $_GET variable to the script processing the data, i.e. <form action="edit.php?processed=1">, and then checking if $_GET['processed'] is set.

Good luck!

[JayDev]

Thanks,

I will try to test this new information since post was not larger than max_upload and neither was memory.

I will look into it.