Export mysql dump file, such that statments are in the order of dependency

I need to create a dump file such t开发者_JAVA百科hat when i execute it, i have no depency issues

1. tables run before queries
2. parent tables before child tables etc
3. no failed insert due to foreign key failures

Two tables may refer each other with FK so not always possible to create and insert "parent first".

Use mysqldump . It will disable foreign keys before importing data and enable afterward. (this is also much faster).