Answers for "mysq import statmenet faster"

SQL
0

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;
Posted by: Guest on November-04-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language