Some proposals:
- truncate table as new option (instead of drop/create table)
- option to select all tables but no modx_log tables and no modx_manager_log table
- insert SET FOREIGN_KEY_CHECKS=0; at the begin and SET FOREIGN_KEY_CHECKS=1; at the end of the script - everytime I make a dump I have to insert it manually
- optional: insert use database name at the begin of the script