/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

4 votes269 views2 answers
Convert utc to est sql
SQL
1 vote276 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote274 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote270 views3 answers
Classement rang mysql 7
SQL
0 vote293 views1 answer
Alter domain sql
SQL
0 vote258 views1 answer
Create new schema mysql
SQL
1 vote262 views1 answer
Select dba users oracle
SQL
2 votes273 views2 answers
Enable foreign key checks postgres
SQL
0 vote251 views1 answer
How to connect to mysql in ef 6
SQL
0 vote263 views1 answer
Select all tables linked server sql
SQL