If there is a limit on the files size which has to be uploaded from server end (for ex: uploading a file through an HTML form) we must increase the threshold value of the file size capacity. By default, file size limit is 2MB or the import size in PHPMyAdmin, that makes it difficult to import larger files. We can increase the upload file capacity by editing php.ini configuration file.

The values to change are:

Usually in Xampp php.ini configuration file is located in xampp/php/php.ini (Type of file: Configuration settings). We must ensure that post_max_size is the same or larger than upload_max_filesize. Find the following parameters (CTRL+F) and change their values to more than your database size for ex:

After changing the values, remember to restart your web server.

Note:
» phpMyAdmin is a free and open source and cross platform tool for the administration of MySQL or MariaDB via a web browser.
» Xampp is an acronym for X (any Operating System), Apache(Web server), MySQL Database, PHP Language and PERL.
» WAMP is an acronym for Windows (OS), Apache (web-server), MySQL (database), PHP (language).