Bewertung: 5 / 5

there are 2 tool for dump and import on Linux Shell.

For export you can use:

mysqldump -u <USER> -p <Database> > <SafeFile>.dmp

This create a file whith the database structure.

For import you can use:

mysql -u <USER> -p <Database> < <SafeFile>.dmp

This create a Database whith the structure from the backup File.

If you want zip your export use:

mysqldump -u <USER> -p <Database> | gzip > <SafeFile>.dmp

If you want create daily a dump and remove old dumps after 14 days this script for bash can help:

#!/bin/bash

DATE=`date +%Y-%m-%d`
DATABASE=
USER=
PASS=

mysqldump -u $USER -p$PASS $DATABASE | gzip > /var/opt/mysqldump/daily-backup-$DATE.gz

find /var/opt/mysqldump -name "daily-backup-*" -atime +14 -exec rm {} \;