Faster mysql imports

#Innodb before import:
SET FOREIGN_KEY_CHECKS = 0;
SET UNIQUE_CHECKS = 0;
SET AUTOCOMMIT = 0;
#After import:
SET UNIQUE_CHECKS = 1;
SET FOREIGN_KEY_CHECKS = 1;
COMMIT;

Source: support.tigertech.net

Faster mysql imports

#To disable MySQL indexes:
ALTER TABLE `table_name` DISABLE KEYS;
#To enable MySQL indexes:
ALTER TABLE `table_name` ENABLE KEYS;

Source: support.tigertech.net

Similar codes

3 votes152 views1 answer
Select sequence oracle
SQL
3 votes166 views3 answers
Update con select postgresql
SQL
0 vote136 views1 answer
Replace multiple string in query sql
SQL
8 votes159 views1 answer
Oracle add datafile to tablespace
SQL
0 vote157 views1 answer
Sql order by except one row
SQL
1 vote137 views1 answer
Mysql select row max date
SQL
1 vote133 views1 answer
Mysql batch insert
SQL
0 vote153 views1 answer
Sql server for loop
SQL
0 vote148 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
10 votes167 views4 answers
Inner join in update query mysql
SQL