/SQL/How to import large sql file in phpmyadmin in ubuntu

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 vote274 views1 answer
Finish transaction sql
SQL
1 vote323 views2 answers
Datetrunc hour snowflake
SQL
0 vote358 views1 answer
Change permission to database mysql
SQL
0 vote335 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote344 views3 answers
Fetlife
SQL
0 vote314 views1 answer
Print orcale
SQL
2 votes353 views3 answers
Row number mysql
SQL
0 vote326 views1 answer
Sql list dates between two dates
SQL
0 vote326 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote318 views1 answer
Cast as decimal postgresql
SQL