Home > Archive > PHP DB > December 2005 > Re: [PHP-DB] range_alloc_block_size
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: [PHP-DB] range_alloc_block_size
|
|
| Aaron Koning 2005-12-16, 7:55 am |
| This could be a number of things. Are you uploading the file in the script?
Then the max_upload_size may have been exceeded. If not, then it could be
the memory_limit, or the max_execution_time. Check your httpd/php error log
(commonly at: /var/log/httpd/error_log) and adjust the referenced variables
in the PHP ini value or using ini_set().
Read this post also:
http://aspn.activestate.com/ASPN/Ma.../php-db/2931073
I can't imagine this is a DB problem.
Aaron
On 12/16/05, Murat Beyhan <beyhan@deprem.gov.tr> wrote:
>
> Hello,
>
> Im using PHP and MySQL
> I try to import txt file to mysql Database
> But file size bigger than 2048KB so I could not import it
> It is related with range_alloc_block_size
> Because in mysql this veriable is 2048.
> If it is possible how can I change this variable.
> Please If somebody knows this help me..
> Thank you...
> Murat
>
>
> ______________________________________
> XamimeLT - installed on mailserver for domain @deprem.gov.tr
> Queries to: postmaster@deprem.gov.tr
> ______________________________________
> The views and opinions expressed in this e-mail message are the sender's
> own
> and do not necessarily represent the views and the opinions of Earthquake
> Research Dept.
> of General Directorate of Disaster Affairs.
>
> Bu e-postadaki fikir ve gorusler gonderenin sahsina ait olup, yasal olarak
> T.C.
> B.I.B. Afet Isleri Gn.Mud. Deprem Arastirma Dairesi'ni baglayici nitelikte
> degildir.
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
| |
| David Robley 2005-12-16, 7:55 am |
| > On 12/16/05, Murat Beyhan <beyhan@deprem.gov.tr> wrote:
Aaron Koning wrote:
[color=darkred]
> This could be a number of things. Are you uploading the file in the
> script? Then the max_upload_size may have been exceeded. If not, then it
> could be the memory_limit, or the max_execution_time. Check your httpd/php
> error log (commonly at: /var/log/httpd/error_log) and adjust the
> referenced variables in the PHP ini value or using ini_set().
>
> Read this post also:
> http://aspn.activestate.com/ASPN/Ma.../php-db/2931073
>
> I can't imagine this is a DB problem.
>
> Aaron
It might well be. There is a config setting in mysql called
max_allowed_packet which might be relevant in this case. IIRC it defaults
to quite a small value. Yes, the default is 1 Mb in versions 3 and 4 of
mysql.
Cheers
--
David Robley
"I joined the Lion's Club," said Tom pridefully.
|
|
|
|
|