Importing text file - maximum filesize

Importing text file - maximum filesize

am 11.02.2006 08:19:16 von Jean Bidule

Hi,

I installed phpmyadmin to test my site on my homecomputer. The table i want
to "upload" in my mysql table is about 5 Mb but in phpMyadmin the maximum
size is 2048 kb.

Where can I change the maximum size of text files in PhpMyAdmin ? Somewhere
in "config.inc.php" ?

Thank you very much
Jean

Re: Importing text file - maximum filesize

am 12.02.2006 03:40:35 von Gufo Rosso

"Jean Bidule" ha scritto nel messaggio
news:43ed8ff4$0$1184$ba620e4c@news.skynet.be...
> Hi,
>
> I installed phpmyadmin to test my site on my homecomputer. The table i
want
> to "upload" in my mysql table is about 5 Mb but in phpMyadmin the maximum
> size is 2048 kb.
>

change php.ini

post_max_size = 80M

and

upload_max_filesize = 55M


> Where can I change the maximum size of text files in PhpMyAdmin ?
Somewhere
> in "config.inc.php" ?
>
> Thank you very much
> Jean
>
>

Re: Importing text file - maximum filesize

am 23.02.2006 09:52:41 von Jim Michaels

"Jean Bidule" wrote in message
news:43ed8ff4$0$1184$ba620e4c@news.skynet.be...
> Hi,
>
> I installed phpmyadmin to test my site on my homecomputer. The table i
> want to "upload" in my mysql table is about 5 Mb but in phpMyadmin the
> maximum size is 2048 kb.

there is a maximum size of a single INSERT statement of 1MB in MySQL I've
heard, so you may need to break them up depending on how you've coded it. I
don't know, but that might be configurable at the database somehow.

php.ini is your problem: try these parameters:
post_max_filesize (set to 4/3 upload_max_filesize)
upload_max_filesize
max_execution_time

>
> Where can I change the maximum size of text files in PhpMyAdmin ?
> Somewhere in "config.inc.php" ?
>
> Thank you very much
> Jean
>
>