Import file size limit in PHPMyAdmin

by

Find the file called: php.ini on your server and follow below steps

With apache2 and php5 installed you need to make three changes in the php.ini file. First open the file for editing, e.g.:

sudo gedit /etc/php5/apache2/php.ini

OR

sudo gedit /etc/php/7.0/apache2/php.ini

Next, search for the post_max_size entry, and enter a larger number than the size of your database (15M in this case), for example:

post_max_size = 25M

Next edit the entry for memory_limit and give it a larger value than the one given to post_max_size.

Then ensure the value of upload_max_filesize is smaller than post_max_size.

The order from biggest to smallest should be:

    memory_limit
    post_max_size
    upload_max_filesize

After saving the file, restart apache (e.g. sudo /etc/init.d/apache2 restart) and you are set.

Don’t forget to Restart Apache Services for changes to be applied.

More Related Contents:

  1. Can I store query result of one field into different variables? if not then what should I do for that?
  2. The requested URL was not found on this server.
  3. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  4. How to write a stored procedure using phpmyadmin and how to use it through php?
  5. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  6. Mysql event error using php
  7. Access denied for user ‘root’@’localhost’ with PHPMyAdmin
  8. Store procedures in phpMyAdmin
  9. How to solve time out in phpmyadmin?
  10. WAMP/MySQL errors not in correct language
  11. phpmyadmin automatic logout time
  12. #1193 – Unknown system variable ‘lc_messages’ when trying to login to phpmyadmin
  13. Unknown database error in PHP but it exists in PHPMyAdmin
  14. Extension mysqli is missing, phpmyadmin doesn’t work
  15. How to SELECT DEFAULT value of a field
  16. How to log in to phpMyAdmin with WAMP, what is the username and password?
  17. Auto Increment skipping numbers?
  18. How to write a stored procedure in phpMyAdmin?
  19. Installing PDO driver on MySQL Linux server
  20. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’
  21. Fixing broken UTF-8 encoding
  22. Export MySQL data to Excel in PHP
  23. MySQL – ignore insert error: duplicate entry
  24. Call to a member function execute() on boolean in [duplicate]
  25. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  26. Find Point in polygon PHP
  27. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  28. Setting a connect timeout with PDO
  29. Remotely connecting to a MySQL database
  30. Limit pagination page number

Leave a Comment