Sql

Search

import large .sql files into lampp

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

->phpMyAdminlibrariesconfig.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

Comment

PREVIOUS	NEXT

Code Example
Sql :: Alter table add column in SQL Server- NAYCode.com
Sql :: SHOW COLUMNS Statement
Sql :: postgresql dump and restore db
Sql :: date between in mysql
Sql :: mysql select multiple rows into one column
Sql :: SQL Auto Increment Primary Key - SQL Server
Sql :: date to string mariadb
Sql :: When mysql server would not work in xampp
Sql :: command line mysql xampp
Sql :: postgres set column based on another column
Sql :: find lowest number in sql
Sql :: select count
Sql :: sql server list locks
Sql :: mysql on duplicate key update
Sql :: run mysql file in terminal
Sql :: mysql update add to existing value
Sql :: sql server output parameter
Sql :: mysql count with if
Sql :: create index mysql cli
Sql :: how to insert ip address in mysql using php
Sql :: create mysql database on windows
Sql :: SQL DEFAULT Constraint With Alter Table
Sql :: update table from another table
Sql :: create table split string function in sql server
Sql :: how to combine diff colmun value using group by postgres
Sql :: incompatible sql_mode=only_full_group_by
Sql :: mysql récupérer le code création de vue
Sql :: show database cmd
Sql :: Postgres - Login and connect as default user
Sql :: activate log mariadb

Search

SQL

import large .sql files into lampp

ADD CONTENT