var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: import large .sql file
two way to upload sql file
mysql -u user name -p databasename<filename.sql
I want to upload large sql file 2 GB that will take long time to upload
is there any way to uplaod in fast many where we can use bulk insert
or any change in configration file my.ini to make fast upload
I don't think there is a way to upload it faster than the command line, any one's suggestion?
Depending on your influence on the source file you may try to build it with bulk inserts instead of single row inserts:
insert into tbl_a (x,y) values (1,2), (4,5),...,(33,2);
in addition to this you can disable index maintenance for non unique keys for the affected tables first by
alter table tbl_a disable keys;
alter table tbl_a enable keys;
Hope this helps.