Breaking News: Grepper is joining You.com. Read the official announcement!

import large .sql files into lampp

uzii answered on August 11, 2021 Popularity 10/10 Helpfulness 5/10

answer import large .sql files into lampp

import large .sql files into lampp

Comment

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

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: file import lampp phpmyadmin sql ubuntu

Link to this answer
Share Copy Link

Contributed on Aug 11 2021

uzii

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

import large .sql files into lampp

Contents

More Related Answers

import large .sql files into lampp

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.