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

0 vote136 views1 answer
How to subquey to do not load in live database in
SQL
0 vote108 views1 answer
Wordpress sql find and replace
SQL
6 votes130 views2 answers
Psql load dump
SQL
0 vote108 views1 answer
Import all databases mysql
SQL
0 vote121 views1 answer
Mysql export search results
SQL
0 vote118 views1 answer
Sql query tags
SQL
0 vote129 views1 answer
Get rows from 1 table with other table empty mysql
SQL
2 votes138 views1 answer
Power query concatenate
SQL
1 vote131 views1 answer
Mysql breakline on string
SQL
5 votes114 views1 answer
How to check port number for postgresql
SQL