====== MySQL: Backup ======

===== Export a Database =====

<code bash>
# set or replace the variables $USER, $PASS and $DB
mysqldump --add-drop-table -u${USER} -p${PASS} ${DB}
</code>

===== Export all Databases individually =====

<code bash>
# set or replace the variables $USER and $PASS
DATE_YMD=$(date "+%Y-%m-%d")
DATABASES=$(mysql --batch -u${USER} -p${PASS} mysql --execute='show databases')
for db in ${DATABASES}
do
    mysqldump --add-drop-table -u${USER} -p${PASS} ${DB} > ${DB}_${DATE_YMD}.sql &
    bzip2 ${DB}_${DATE_YMD}.sql &
    # sleep 10 # optional
done
wait # for child processes to end
</code>

{{tag>mysql admin backup export}}