Backup e Restore via Dump no MySQL

Antes de começarmos vamos definir algumas variaveis para melhor entendimento:

user=root
password=P@ssw0rd
host=localhost
database=bugtracker
dir=/root/Backup

1 -Fazendo backup

Vamos fazer o backup da database bugtracker:

# mysqldump -h $host -u $user -p$password $database > $DIR

2 - Restaurando o backup

Imaginando que perdemos o banco vamos restaura-lo:

# mysql -u root -p
# create database bugtracker;
# use bugtracker;
# source /root/Backup/meuBanco_080415.sql;

Segue abaixo um simples script de backup de uma determinada tabela:

#######################################################
#!/bin/sh
DATA=`/bin/date +%y%m%d`
DIR="/root/Backup/meuBanco_$DATA.sql"
# variaveis do MySQL
HOST="localhost"
USER="root"
PASS="P@ssw0rd"
DATABASE="bugtracker"
# Executa o backup
mysqldump -h $HOST -u $USER -p$PASS $DATABASE > $DIR
########################################################