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
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}