import large sql files into lampp

Solutions on MaxInterview for import large sql files into lampp by the best coders in the world

Search
showing results for - "import large sql files into lampp"
Wyatt
11 Feb 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
similar questions
mysql import gzip dbxampp import sql file command linespark sql grows beyond 64 kbimport big data to mysqlalter database datafile maxsize 32gsql full backup compression sizequery for backup a database at another location in file systemmysql db dump restore max file size issuehoq to import database sourcebigrock database connection stringimport database in mysql command line xamppimport mysql dump database command line linuxmysql import data from large csv filemysql dump database gzipcompress sql file database ubuntu
queries leading to this page
how to import large sql file in phpmyadminimport large database phpmyadmin command linehow to import large db in phpmyadminhow to import large sql file in phpmyadmin xampp shellupload large sql file to phpmyadminhow to import large sql file in phpmyadmin xamppupload large sql file to phpmyadmin command linehow to import large database in phpmyadminhow to upload large sql file in phpmyadminhow to import large sql file in phpmyadmin cpanelimport large database in phpmyadminimport big sql file phpmyadminphpmyadmin import large sqlphpmyadmin import large sql filehow to import large mysql database in phpmyadminimport big sql file phpmyadmin with terminalimport large sql file in phpmyadminimport a large database in phpmyadminimport large sql files into lampp ubuntu import big sql file phpmyadminhow to import sql database larger file in phpmyadmin in ubuntuimport large sql files into lamppimport large sql files into lampp