http://img507.imageshack.us/img507/4853/untitled16if.gif

How can ı make this limit bigger...???

Isnt there anyone to help me..:(

Do you have SSH access to your account?

If so you'll find uploading the file and using the command-line mysql tools far more efficient for importing a large amount of data (I assume this is why you need such a large query size).

Do you have SSH access to your account?

If so you'll find uploading the file and using the command-line mysql tools far more efficient for importing a large amount of data (I assume this is why you need such a large query size).


yes i have SSH access..but i danno which file i should edit...:crying:

I'm not sure what to edit to increase the limit - it depends where phpMyAdmin is getting the limit from. It may be "self imposed" in which case you need to edit it's configuration or the limit could be imposed by either PHP or Apache as that have "maximum request size" options. You might need to consult the documentation at http://www.phpmyadmin.net/home_page/docs.php

I was suggesting that you transfer the file to the host, and import the data using the mysql command-line utilities via SSH login:
mysql --user=username -p databasename < filename.sql

Or, could you simply break the long query batch into smaller sections and run them one-by-one in phpMyAdmin?

dspillettt: Are you sure there is a set limit? I think it may just be a limit for phpMyAdmin..

I am pretty sure there is no limit when using the CLI.

dspillettt: Are you sure there is a set limit? I think it may just be a limit for phpMyAdmin..
I am pretty sure there is no limit when using the CLI.

I've always imported/run large blocks of SQL via the command-line tools, where there is no limit, hence I'm not sure where the phpMyAdmin limit is coming from.

It could be it's own local setting (most likely), or it could be picking up the "maximium request size" settings from Apache/PHP.

You could try something like http://www.ozerov.de/bigdump.php for big SQL imports, if you don't want to use the command-line option.

I've just checked the max on one of my servers (a pretty standard cPanel rig), and it claims to be 50Mb - though I would guess that batches much smaller than that could fail due to the "max memory per process" option usually set in PHP to stop one run-away process making a server grind all the way through it's swap space and hang.

dspillettt: the phpmyadmin limit is actually an apache/php limitation