Import large sql files phpmyadmin in windows
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.
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.