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 vote147 views1 answer
Mysql subdate
SQL
0 vote239 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
50 votes249 views6 answers
Sql count duplicate rows
SQL
22 votes145 views4 answers
Show list of users in mysql
SQL
3 votes145 views2 answers
Oracle sql drop sequence
SQL
3 votes139 views3 answers
Mysqldump: couldn
SQL
0 vote154 views1 answer
T sql return on letters only
SQL
5 votes171 views3 answers
Db begintransaction laravel
SQL
5 votes163 views3 answers
String concatenation sql server
SQL
0 vote172 views1 answer
Sql get table last modified time
SQL