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

Advertisements