You can use --no-data to dump only the schema: shell> mysqldump --all-databases --routines --events --triggers --no-data > schema.sql