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

1 vote137 views1 answer
Laravel return list of ids
PHP Laravel
10 votes130 views1 answer
Explode comma php
PHP
7 votes118 views1 answer
Laravel wher in
PHP Laravel
2 votes100 views1 answer
Form action php
PHP
0 vote112 views1 answer
Image not save laravel
PHP Laravel
28 votes119 views6 answers
Laravel make model with migration
PHP Laravel
0 vote110 views1 answer
Package phpoffice/phpexcel is abandoned, you should avoid using it. Use phpoffice/phpspreadsheet instead.
PHP
22 votes112 views3 answers
Whats the difference between using date function and DATETime in php
PHP
5 votes90 views2 answers
Laravel 8 routes namespace
PHP
0 vote100 views1 answer
Explicit Octal numeral notation - PHP 8.1
PHP