Speed up innodb imports
/For a faster "mysqldump" innodb tables
1. mysqldump --opt --user=username --password database > filetosaveto.sql
2. open the dump file put this statement at the beginning of the sql dump text file:
SET AUTOCOMMIT = 0;
SET FOREIGN_KEY_CHECKS=0;
3. put this statement at the end of the sql dump text file:
SET AUTOCOMMIT = 1;
SET FOREIGN_KEY_CHECKS=1
4. mysql --user=username --password database