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 C:xamppphpmyadminconfig.inc.php file.

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

$cfg['UploadDir'] = "upload"

Save the file and create upload folder under phpmyadmin folder.

C:xamppappsphpmyadminupload

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.
555
like
0
dislike
0
mail
flag

You must LOGIN to add comments