import big sql file phpmyadmin

Solutions on MaxInterview for import big sql file phpmyadmin by the best coders in the world

showing results for - "import big sql file phpmyadmin"
Javon
05 Aug 2016
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
Jonathan
23 Jun 2016
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
upload large sql file to phpmyadmin command linehow to import a large sql file in phpmyadminhow to upload large sql file in phpmyadminimport big mysql database phpmyadminimport large sql files into lamppimport a large database in phpmyadminhow to import a large mysql database in phpmyadminphpmyadmin import big fileimport large sql file in phpmyadmin phphow to allow phpmyadmin import big sql file size up to 1 gbhow to import large data through query into mysql database in phpmyadminhow to import large db file to phpmyadminhow to import large sql file in phpmyadminimport large sql files into lampp ubuntuhow to import large sql file in phpmyadmin in ubuntuhow to import large database in phpmyadminimport large sql file in phpmyadmin windowshow to import large sql file in phpmyadmin xamppimport huge sql file phpmyadminimport big sql file phpmyadmin mamphow to import large mysql database in phpmyadminimport large mysql phpmyadminshow import big sql file phpmyadminhow to import a big sql file in mysql phpmyadminphpmyadmin import large sql filephpmyadmin mysql import large databasephpmyadmin import large sqlphp myadmin import big dbhow to import big database in phpmyadmin import big sql file phpmyadminhow to import sql database larger file in phpmyadmin in ubuntuimport big sql file phpmyadminimport large database in phpmyadminhow to import large sql file in phpmyadmin xampp shellupload large sql file to phpmyadminimport large database phpmyadmin command lineupload big database phpmyadminimport large db phpmyadminhow to import large sql file in phpmyadmin cpanelhow to import large mysql database in phpmyadmin very quicklarge file to import sql phpmyadminimport big sql file phpmyadmin with terminalhow to upload big database in phpmyadminhow to import large db in phpmyadminimport large sql file in phpmyadminimport big sql file phpmyadmin