Import large sql files phpmyadmin in windows

by satheeshkumar 2014-01-05 13:01:31

Import large sql files phpmyadmin in windows,

Steps to be followe for importing large sql file in phpmyadmin,

1. Increase the values for upload_max_filesize, memory_limit and post_max_size directories in php.ini as per requirements and restart the server

2. You can upload large sql files by changing some configuration settings in file.

Open the file and look for $cfg['UploadDir'] and update it as $cfg['UploadDir'] = "upload". If you dont find just open a and copy that line and paste into your actuall file and update as i mentioned above. Finally it will be:

$cfg['UploadDir'] = "upload"

Save the file and create upload folder under phpmyadmin folder.


Then copy your all .sql files into this folder.

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

You can now select this and begin the import.

You must LOGIN to add comments