mysqldump
    --host=localhost
    --port=3306
    --databases ****
    --user=****
    --password=****
    --default-character-set=utf8
    --add-drop-database
    --add-drop-table
    --add-locks
    --complete-insert
    --extended-insert
    --lock-all-tables
    --create-options
    --disable-keys
    --quick
    --order-by-primary
    --set-charset
    --tz-utc
    > dump/test.sql

mysqldump
--host=localhost
--port=3306
--databases ****
--user=****
--password=****
--default-character-set=utf8
--opt
--single-transaction
--routines
--triggers
--events
--add-drop-database
--add-drop-table
--complete-insert
--delayed-insert
--tz-utc
> dump/test.sql

SELECT engine,COUNT(1) TableCount
FROM information_schema.tables
WHERE engine IN ('InnoDB','MyISAM')
AND table_schema NOT IN ('information_schema','mysql','performance_schema')
GROUP BY engine;

mysqldump
--host=localhost
--port=3306
--databases ****
--user=****
--password=****
--single-transaction
--routines
--triggers
--events
--add-drop-database
> dump/test.sql