Import large .sql files into lampp

->/opt/lampp/etc/php.ini
1)increase them accordingly 
 post_max_size=500M
upload_max_filesize=500M
max_input_time = 600
memory_limit=900M
max_execution_time=-1

->in opt/lampp/etc/my.cnf
max_allowed_packet=1000
innodb_log_file_size = 50M

->phpMyAdmin\libraries\config.default.php
$cfg['ExecTimeLimit'] = 0;
______________________________________________
2nd method 

goto lampp/phpmyadmin
create two folders in the same directory namely save and upload 

goto lampp/phpmyadmin/config.inc.php
$cfg['UploadDir'] = '/opt/lampp/phpmyadmin/upload';
$cfg['SaveDir'] = '/opt/lampp/phpmyadmin/save';

save 
and then put the large .SQL file into the upload folder 
it will come under the import page automatically

Similar codes

3 votes90 views2 answers
How to start mysql in terminal
SQL
1 vote97 views1 answer
Substr sql last character
SQL
0 vote142 views1 answer
AddEntityFrameworkSqlite
SQL
1 vote93 views1 answer
Sql server reseed single table
SQL
0 vote101 views1 answer
Sql sort ages
SQL
0 vote110 views2 answers
How to display enum value sql server
SQL
2 votes102 views4 answers
How to find 2nd highest salary in mysql
SQL
1 vote119 views1 answer
Sql row having max
SQL
18 votes112 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
5 votes95 views1 answer
Mysql get last day of month
SQL