How to resolve file size error while restoring mysql backup ?
When we try to restore mysql backup from phpmyadmin,it shows us that file upload limit is 2Mb. If our database size is greater than 2Mb,we can not restore the database. To resolve this issue, we need to increase the file upload limit in php configuration.
open /etc/php5/apache2/php.ini and change the following parameter.
(php.ini may be located at different place depending upon different php versions)
upload_max_filesize = 400M
After the change restart the apache service.
service apache2 restart
Now, we can restore mysql backup up to 400Mb