Import large files mysql phpmyadmin localhost

Posted by & filed under MYSQL, PHP.

I had this problem when i’m try to upload 8MB file into the localhost, I had the following

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

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

When trying to import large SQL files into mysql using phpmyadmin, the phpmyadmin documentation offers a few solutions, but I find the easiest method to overcome this is…
Find the config.inc.php file located in the phpmyadmin directory. In my case it is located here:

1. C:\xampp\phpMyAdmin\config.inc.php

Find the line with $cfg[‘UploadDir’] in the config.inc.php and update the line this

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

If you don’t find just open a config.sample.inc.php and copy that line and paste into your actual config.inc.php file and update as i mentioned above. Finally it will be:

3.  $cfg['UploadDir'] = "upload"

Save the file and create upload folder under phpmyadmin folder.

 4. C:\xampp\phpMyAdmin\upload

Then copy your all .sql files into the upload folder in the phpmyadmin like this

Copy and save all the .sql files in the upload folder in the phpmyadmin

Now when you go to phpmyadmin import page you will see  a drop down with list of .sql files below the browse button.

If you finished above steps successfully now you can upload all .sql files in the localhost.

Sometimes if you have problem like this follow the below steps :

If you get Script timeout passed, if you want to finish import, please resubmit same file and import will resume.

add $cfg['ExecTimeLimit'] = 0; this line in config.inc.php file.
 By default setting for ExecTimeLimit is 300 seconds.

 .

Download Premium Only Scripts & 80+ Demo scripts Instantly at just 1.95 USD per month + 10% discount to all Exclusive Scripts

If you want any of my script need to be customized according to your business requirement,

Please feel free to contact me [at] muni2explore[at]gmail.com

Note: But it will be charged based on your customization requirement

Get Updates, Scripts & Other Useful Resources to your Email

Join 10,000+ Happy Subscribers on feedburner. Click to Subscribe (We don't send spam)
Every Email Subsciber could have access to download 100+ demo scripts & all future scripts.

Get Instant Script Download Access!