--routines -> FALSE by default
--event -> FALSE by default
--triggers -> FALSE by default
如果只用到 routines and event .那麼 Dump 語法:
QUOTE:
mysqldump <other mysqldump options> --routines --event > /tmp/outputfile.sql
匯入的話就照正常的語法:
QUOTE:
mysql db < /tmp/outputfile.sql
這樣就可以囉...