Sometimes when trying to upload some huge SQL file using PHPMYADMIN we might come across this ERROR MESSAGE

Error: You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit

There is simple a fix for this:-
Find the config.inc.php file located in the phpmyadmin directory. In my case it is located here:

H:\xampp\phpMyAdmin\upload\config.inc.php

Find the line with $cfg['UploadDir'] on it and update it to:

$cfg['UploadDir'] = 'upload';

Create a directory called ‘upload’ within the phpmyadmin directory.

C:\wamp\apps\phpmyadmin3.2.0.1\upload\

Then place the large sql file that you are trying to import into the new upload directory. Now when you go onto the db import page within phpmyadmin console you will notice a drop down present that wasn’t there before – it contains all of the sql files in the upload directory that you have just created. You can now select this and begin the import.

The new option that you see in the import page will be similar to this

Import large files in mysql using PhpMyAdmin, 8.0 out of 10 based on 4 ratings

Incoming search terms:

• phpmyadmin import large file (41)
• import large file phpmyadmin (24)
• phpmyadmin import large files (15)
• import inurl:/register intext:upcoming intext:published intext:submit intext:tag cloud -inurl: php (11)
• how to import large file in phpmyadmin (11)
• import large files phpmyadmin (9)
• how to import large files in phpmyadmin (9)
• phpmyadmin import big file (9)
• you probably tried to upload too large file mysql (8)
• xampp phpmyadmin upload limit (7)
• phpmyadmin import big files (7)
• wamp You probably tried to upload too large file Please refer to documentation for ways to workaround this limit (6)
• you probably tried to upload too large file phpmyadmin (6)
• you probably tried to upload too large file phpmyadmin xampp (6)
• you probably tried to upload too large file in xampp (6)
• phpmyadmin import multiple files (5)
• upload large files in phpmyadmin (5)
• you probably tried to upload too large file please refer to documentation for ways to workaround this limit open new phpmyadmin window (5)
• phpmyadmin large file import (5)
• you probably tried to upload too large file xampp phpmyadmin (5)
• how to import big file to phpmyadmin (5)
• import large file in phpmyadmin (5)
• Imported file compression will be automatically detected from: None gzip (5)
• mysql You probably tried to upload too large file (4)
• phpmyadmin import large csv file (4)
• upload large files mysql (4)
• Importing large files into mysql with phpmyadmin xampp (4)
• how to import big file in phpmyadmin (4)
• xampp mysql import limit (4)
• xampp You probably tried to upload too large file phpmyadmin (4)
• xammp you are trying to upload to large file (3)
• Importing large files into mysql with xampp (3)
• how to upload large mysql file (3)
• xamp You probably tried to upload too large file Please refer to documentation for ways to workaround this limit (3)
• how to change import size in xampp (3)
• how to upload large files mysql (3)
• how to import large sql file in phpmyadmin (3)
• how to upload large files in phpmyadmin (3)
• xampp $cfg[UploadDir] (3)
• xammpyou probably tried to upload too large file please refer to documentation for ways to workaround this limit (3)

You will also be interested in ,

• make_sock: could not bind to address 0.0.0.0:80 windows apache not starting [Solved]
• Adding apache handlers in cpanel
• mod_proxy_balancer and installation
• How to install XAMPP
• Url rewriting examples using .htaccess
• Speed up wordpress using .htaccess part 2
• Speed up wordpress using .htaccess part 1
• Apache AddHandler application/x-httpd-php not working?
• IE compatibility view force Internet Explorer to use Internet Explorer 7 rendering mode
• Remote Mysql Connection From CPANEL And Connect To MYSQL Database From Your Local Webserver or Other External Web Server