#!/bin/bash prefixe=backup suffixe=$(date +%Y%m%d) filename=$prefixe$suffixe.sql host=host database=database user=user characterSet=UTF8 mysqldump --skip-comments \ --complete-insert \ --default-character-set=$characterSet \ --no-create-info \ --skip-add-locks \ --skip-opt \ --host $host \ --user $user \ -p $database > $filename sed -i "1iuse $database;\nSET CHARACTER SET '$characterSet';" $filename exit 0