Import large sql files phpmyadmin in windows

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.

Tagged in:

• xampp
• phpmyadmin
• file upload
• SQL