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 vote362 views1 answer
Woocommerce get the price from session after add to cart
PHP
35 votes328 views6 answers
Php current time
PHP
1 vote339 views1 answer
Enable extensions in php.ini
PHP
0 vote328 views1 answer
Yii1 findall as array listData
PHP
1 vote348 views3 answers
Laravel syncwithoutdetaching
PHP
0 vote392 views1 answer
Laravel select option form add please select option
PHP Laravel
2 votes326 views1 answer
Merubah judul menjadi slug codeigniter
PHP
6 votes350 views2 answers
Refused to connect iframe php
PHP
31 votes365 views6 answers
Laravel update
PHP Laravel
0 vote331 views1 answer
Change arabic number to english php
PHP