phpMyAdmin: During SQL Imports What Does kKiB Mean, How to Modify Max File Import Size
Recently I had to import some files via phpMyAdmin because the web host of my client didn’t allow SSH access to the server or direct access to the MySQL command line. The need was to create a database and restore a previous backup from another database into MySQL. I noticed that on the Import screen there were a couple things I was curious about. First what kKiB meant and if I wanted to how would I change the max size file I could import.
What does kKiB Mean?
kKiB means Kilo Kibibyte. To expand a little bit more a Kilo Kibibyte is similar to a MegaByte. If you have 100 kKiB this is the same as 100 MB.
How can I modify phpMyAdmin max upload size?
Modify your php.ini file which is typically located in the /etc directory. Add or modify the below parameters.
- post_max_size = 240M
- upload_max_filesize = 240M
After making modifications to the php.ini file you must restart your web server for the changes to take effect.
Be careful though because if you have public facing PHP scripts then opening up these options can cause security concerns. These limits are also set so a process does not get stuck taking up valuable resources.