Tutorial that teaches you step by step how to change the size limit accepted for the import of SQL files into phpmyadmin. Help when you need to import big databases. Change Upload Size Limit Sql File in Phpmyadmin.
When we have work with databases, the most handy is us phpMyAdmin, which provides us with support for administration of the dating bases EPRIN the web interface. From Phpmyadmin we can make any changes we want in a database to which we have access. We can add databases, create, delete and edit tables in databases, we can delete or we can It matters Baze from dates.
In the standard (default) configuration “Import” FROM phpMyAdmin, does not allow us to upload in MySQL to files greater than 2MB (2,048 CIB). If we have an important database greater than 2 MB, then the error comes: “You probably tried to upload too large file. Please referer to documentation for ways to workaround this limit.“
A solution to compress the database (.SQL file) in one of the formats gzip, bzip2 or zip, but if the database file is very large, then certainly by compression we will not get a file below 2MB that can be wrapped by phpMyAdmin. The only solution is to change the limit of the limit allowed for upload.
Change Upload / Import Size Limit in phpMyAdmin
Import limit is given by configuration PHPto the limit, and to change this limit we will have to edit the file that is responsible for the PHP configuration (PHP.ini).
Depending on the system used, PHP.ini can be located in “/etc/php.ini“, “/etc/php5/apache2/php.ini” or in another location on web server. The simplest to locate it is to log on to the server (via SSH) and give the order line “locate php.ini“. After locating the php.ini file, we go to its editing.
nano /etc/php.ini
In the file php.ini We are looking for and editing the following lines:
max_execution_time = 60 ; Maximum execution time of each script, in seconds (def. 30)
max_input_time = 90 ; Maximum amount of time each script may spend parsing request data (def. 60)
memory_limit = 128M ; Maximum amount of memory a script may consume (def. 128mb)
upload_max_filesize = 200M ; Maximum allowed size for uploaded files. (def. 2mb)
post_max_size = 180M ; Maximum size of POST data that PHP will acceptIn our case we have set that the maximum size of the import file should not be greater than 180MB. This means that we can import through PHPmyadmin databases up to 180MB.
Founded by your needs. Change the execution time and memory limit used. If the times set in php.ini are small and the import file is very high, then it is possible to give the error “time out” at import. For this you will need to change “max_input_time” and “max_execution_time“. This is also true for the memory limit, which must be increased in the case of large databases. After making the changes, using the editor “nano”, press Ctrl + X then “Y” (Yes) si Enter to save the changes.
The last step is the restart Apache Web Server.
systemctl restart httpd or
/etc/init.d/httpd restartAfter the restart of apache You can start importing the file with the database.
Stealth Settings – Change Import Size Limit in phpMyAdmin.
Old tutorial but it is still topical. Thank you!
However, it does not work in all situations. Connection Timed Out to Upload.