how to import large sql file in phpmyadmin in ubuntu

Solutions on MaxInterview for how to import large sql file in phpmyadmin in ubuntu by the best coders in the world

showing results for - "how to import large sql file in phpmyadmin in ubuntu"
Lilac
13 Sep 2017
1->/opt/lampp/etc/php.ini
21)increase them accordingly 
3 post_max_size=500M
4upload_max_filesize=500M
5max_input_time = 600
6memory_limit=900M
7max_execution_time=-1
8
9->in opt/lampp/etc/my.cnf
10max_allowed_packet=1000
11innodb_log_file_size = 50M
12
13->phpMyAdmin\libraries\config.default.php
14$cfg['ExecTimeLimit'] = 0;
15______________________________________________
162nd method 
17
18goto lampp/phpmyadmin
19create two folders in the same directory namely save and upload 
20
21goto lampp/phpmyadmin/config.inc.php
22$cfg['UploadDir'] = '/opt/lampp/phpmyadmin/upload';
23$cfg['SaveDir'] = '/opt/lampp/phpmyadmin/save';
24
25save 
26and then put the large .SQL file into the upload folder 
27it will come under the import page automatically
28
Leonardo
14 Feb 2020
1Try to import it from mysql console as per the taste of your OS.
2
3mysql -u {DB-USER-NAME} -p {DB-NAME} < {db.file.sql path}
4or if it's on a remote server use the -h flag to specify the host.
5
6mysql -u {DB-USER-NAME} -h {MySQL-SERVER-HOST-NAME} -p {DB-NAME} < {db.file.sql path}
queries leading to this page
how to upload big database in phpmyadminhow to import large sql file in phpmyadminimport large mysql phpmyadminhow to import large sql file in phpmyadmin in ubuntuimport large sql file in phpmyadmin phpimport big mysql database phpmyadminimport large database phpmyadmin command linephpmyadmin mysql import large databaseupload big database phpmyadminshow import big sql file phpmyadminhow to import large db in phpmyadminhow to import large sql file in phpmyadmin xampp shellupload large sql file to phpmyadminhow to import large db file to phpmyadminimport large db phpmyadminhow to import large sql file in phpmyadmin xamppupload large sql file to phpmyadmin command linehow to import big database in phpmyadminhow to import large mysql database in phpmyadmin very quickhow to import large database in phpmyadminimport big sql file phpmyadmin mamphow to upload large sql file in phpmyadminphp myadmin import big dbhow to import a large sql file in phpmyadminhow to import a large mysql database in phpmyadminhow to import large sql file in phpmyadmin cpanelimport large database in phpmyadminhow to import large data through query into mysql database in phpmyadminimport big sql file phpmyadminphpmyadmin import large sqlimport huge sql file phpmyadminphpmyadmin import large sql filehow to import large mysql database in phpmyadminimport big sql file phpmyadmin with terminalimport large sql file in phpmyadminphpmyadmin import big fileimport large sql file in phpmyadmin windowsimport a large database in phpmyadminhow to allow phpmyadmin import big sql file size up to 1 gblarge file to import sql phpmyadminimport large sql files into lampp ubuntuhow to import a big sql file in mysql phpmyadmin import big sql file phpmyadminhow to import sql database larger file in phpmyadmin in ubuntuimport large sql files into lampphow to import large sql file in phpmyadmin in ubuntu