Home Server Tutorials Increase Upload Max File Size Limit In PHPMyAdmin

Increase Upload Max File Size Limit In PHPMyAdmin

If you want to increase upload file size limit in PHPMyAdmin on CentOS then follow the complete instructions from this post.

The reason doing this if you fail to import your .sql file to the PHPMyAdmin due to limited uploading maximum file size.

How to increase upload max file size limit in PHPMyAdmin

You need to have SSH access to remote server that can be done using Putty.

Then login using your root and password.

Enter Username And Password SSH Putty

After that, execute the following command:

nano /etc/php.ini
Upload Upload File Size Limite MySQL PHPMyAdmin

Then use the CTRL + W to search d the following:

1. To increase Upload Max File Size

Type this: upload_max_filesize.

Upload File Size Limit

Then change the size to whatever number you like.

Change Upload Max File Size Limit MySQL

2. To increase Post Max Size

Type this: post_max_size.

Change Post Max Size

Then change the number to whatever number you like.

Change Post Max Size Limit

Once done, just click CTRL + X on keyboard then type Y->Enter and hit Enter again. Then run this command:

apachectl restart
Apachectl Restart
Now this my result, I change the upload max file size to be 120M, now my importing file size maximal is 120M as it can be seen on the following screenshot:
Increase Importing File Size On MyPHPAdmin

LEAVE A REPLY

Please enter your comment!
Please enter your name here