Upper limit for load limit and post limit in PHP

Question

I changed the upload and send settings to 8000 M. However, when I try to import a table from a text file that has only 12.4 MB, I get an error message:

You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit. 

Is 8000 M big?

Answer 1

Be careful not to exceed the 32-bit signed integer (if you are using 32-bit versions) as this will crash your script.

http://www.php.net/manual/en/ini.core.php#ini.post-max-size

Answer 2

First check these values ​​in php.ini

max_execution_time

max_input_time

memory_limit

I would also lower your post_max_size and upload_max_size to a more reasonable level (e.g. 128 or 256 M).

Also, if you really need to get data, you can do this from the command line

 mysql -u username -p database < dump.sql 

Answer 3

copy and paste below: http://daipratt.co.uk/importing-large-files-into-mysql-with-phpmyadmin/

How I overcame the same problem.

When trying to import large SQL files into mysql using phpmyadmin, the phpmyadmin documentation offers several solutions, but I find the easiest way to overcome this ...

Locate the config.inc.php file located in the phpmyadmin directory. In my case, it is here :? one
C: \ WAMP \ applications \ phpmyadmin3.2.0.1 \ config.inc.php

Find the line with $ cfg ['UploadDir'] and update it to :? one
$ cfg ['UploadDir'] = 'upload';

Create a directory named 'upload in the phpmyadmin directory.? 1 C: \ wamp \ apps \ phpmyadmin3.2.0.1 \ upload \

Then put the large sql file that you are trying to import into the new download directory. Now, when you go to the db import page inside the phpmyadmin console, you will notice a drop-down gift that has not been there before - it contains all the sql files in the download that you just created. Now you can select this and start importing.

If you are not using WAMP on Windows, then I am sure that you can adapt this to your environment without any problems.

Answer 4

I believe the problem is that you have exceeded the limit of 3.2 GB (8 000 MB) introduced by the 32-bit process with PHP. So you probably won't be able to use all 8,000 MB, as you indicated. I had PHP freezing code while processing around 2000 MB as memory for use with 32-bit PHP.