While we importing database into MySQL via phpMyAdmin, It may show a massege like this, " No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration ". It can be solved by increasing the following parameters in the
php.ini file.
To increase MySQL phpmyadmin import file size in Ubuntu 16.04 or newer, follow these steps. In the newest Ubuntu version you can have either PHP 5 or PHP 7.
Step - 1: To Check php version, execute
php --version in terminal
Step - 2: open php.ini of the appropriate PHP version(s).
For PHP v5.0
sudo -H gedit /etc/php5/apache2/php.ini
For PHP v7.0
sudo -H gedit /etc/php/7.0/apache2/php.ini
For PHP v7.1
sudo -H gedit /etc/php/7.1/apache2/php.ini
For PHP v7.2
sudo -H gedit /etc/php/7.2/apache2/php.ini
For PHP v7.3
sudo -H gedit /etc/php/7.3/apache2/php.ini
Step - 3: Now need to increase below parameters in the php.ini file. (search these in php.in and make changes. It will be assigned 2M by default)
memory_limit = 120M
post_max_size = 120M
upload_max_filesize = 120M
Please Note : post_max_size should be larger than upload_max_size
Step - 4: Now you need to restart your apache server to effect changes.
sudo service apache2 restart
