Import big sql file phpmyadmin

How to import large sql file in phpmyadmin in ubuntu

->/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

Import big sql file phpmyadmin

Try to import it from mysql console as per the taste of your OS.

mysql -u {DB-USER-NAME} -p {DB-NAME} < {db.file.sql path}
or if it's on a remote server use the -h flag to specify the host.

mysql -u {DB-USER-NAME} -h {MySQL-SERVER-HOST-NAME} -p {DB-NAME} < {db.file.sql path}

Similar codes

0 vote157 views1 answer
Laravel get all old input
PHP Laravel
0 vote118 views1 answer
Laravel how to address to git repo for develop packages
PHP
0 vote144 views1 answer
Var_dump beautifier
PHP
0 vote89 views1 answer
Add field to migration laravel
PHP
1 vote162 views1 answer
Exec command not working in php but works in terminal
PHP
0 vote108 views1 answer
Cross-site request forgery validation failed. Required param "state" missing from persistent data
PHP
0 vote111 views1 answer
Auto submit button php
PHP
9 votes140 views6 answers
Php cors
PHP
5 votes142 views2 answers
Created_at default value laravel
PHP Laravel
5 votes123 views2 answers
Check session in blade laravel
PHP