How to fix “no data received to import” error, in phpMyAdmin

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 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

0 Komentar