import large sql files into lampp

Solutions on MaxInterview for import large sql files into lampp by the best coders in the world

showing results for - "import large sql files into lampp"
Wyatt
11 Feb 2016
1->/opt/lampp/etc/php.ini
21)increase them accordingly 
3 post_max_size=500M
4upload_max_filesize=500M
5max_input_time = 600
6memory_limit=900M
7max_execution_time=-1
8
9->in opt/lampp/etc/my.cnf
10max_allowed_packet=1000
11innodb_log_file_size = 50M
12
13->phpMyAdmin\libraries\config.default.php
14$cfg['ExecTimeLimit'] = 0;
15______________________________________________
162nd method 
17
18goto lampp/phpmyadmin
19create two folders in the same directory namely save and upload 
20
21goto lampp/phpmyadmin/config.inc.php
22$cfg['UploadDir'] = '/opt/lampp/phpmyadmin/upload';
23$cfg['SaveDir'] = '/opt/lampp/phpmyadmin/save';
24
25save 
26and then put the large .SQL file into the upload folder 
27it will come under the import page automatically
28