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

10 votes174 views2 answers
Show tables in schema oracle
SQL
0 vote245 views1 answer
Mariadb hours between two dates
SQL
1 vote170 views1 answer
GROUP BY clause; this is incompati
SQL
4 votes119 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote165 views1 answer
Back up stored procedures mysql
SQL
0 vote178 views1 answer
Sql update subtract value
SQL
0 vote228 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote158 views2 answers
Get top 1 row of each group
SQL
0 vote209 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote167 views1 answer
Oracle character index
SQL