/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 vote297 views1 answer
Mysql add to number
SQL
0 vote246 views8 answers
Convert sql query to linq online
SQL
5 votes294 views4 answers
Upload database mysql command line
SQL
0 vote274 views1 answer
How to close external sql connection in laravel
SQL
3 votes252 views1 answer
Oracle detect invalid password
SQL
0 vote260 views2 answers
Cascade syntax in sql
SQL
2 votes306 views2 answers
Create temporary table in mysql
SQL
0 vote258 views1 answer
Create table Statement Syntax in SQL Server
SQL
11 votes263 views2 answers
MySQL DISTINCT
SQL
17 votes326 views1 answer
Selecting name that contain certain word in sql
SQL