Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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 by support.tigertech.net #
 
PREVIOUS NEXT
Tagged: #faster #mysql #imports
ADD COMMENT
Topic
Name
8+2 =