for “mysqldump” ing innodb tables

take the dump as you would normally do using mysqldump

open the dump file put this statement at the beginning

SET FOREIGN_KEY_CHECKS=0;

of the sql dump text file

and import the same file as you would nomally import an sql dump file