Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # List of databases to be backed up separated by space
- dblist="nombre_bd"
- user="usuario"
- pass="password"
- # Directory for backups
- backupdir=/home/.bacukp/db
- # Number of versions to keep
- numversions=4
- # Full path for MySQL hotcopy command
- # Please put credentials into /root/.my.cnf
- #hotcopycmd=/usr/bin/mysqlhotcopy
- hotcopycmd="/usr/bin/mysqldump -u$user -p$pass --lock-tables --databases"
- # Create directory if needed
- mkdir -p "$backupdir"
- if [ ! -d "$backupdir" ]; then
- echo "Invalid directory: $backupdir"
- exit 1
- fi
- # Hotcopy begins here
- echo "Dumping MySQL Databases..."
- RC=0
- for database in $dblist; do
- echo
- echo "Dumping $database ..."
- mv "$backupdir/$database.gz" "$backupdir/$database.0.gz" 2> /dev/null
- $hotcopycmd $database | gzip > "$backupdir/$database.gz"
- RC=$?
- if [ $RC -gt 0 ]; then
- continue;
- fi
- # Rollover the backup directories
- rm -fr "$backupdir/$database.$numversions.gz" 2> /dev/null
- i=$numversions
- while [ $i -gt 0 ]; do
- mv "$backupdir/$database.`expr $i - 1`.gz" "$backupdir/$database.$i.gz" 2> /dev/null
- i=`expr $i - 1`
- done
- done
- if [ $RC -gt 0 ]; then
- echo "MySQL Dump failed!"
- exit $RC
- else
- # Hotcopy is complete. List the backup versions!
- ls -l "$backupdir"
- echo "MySQL Dump is complete!"
- fi
- exit 0
- Dumping MySQL Databases...
- Dumping base_de_datos ...
- Warning: Using a password on the command line interface can be insecure.
- total 235280
- .... lista de archivos de copias de seguridad
- MySQL Dump is complete!
- hotcopycmd="/usr/bin/mysqldump -u$user -p$pass --lock-tables --databases"
- # Please put credentials into /root/.my.cnf
- #hotcopycmd=/usr/bin/mysqlhotcopy
- [client]
- host = localhost
- user = usuario
- password = password
- socket = <el que sea u omitirlo>
- hotcopycmd="/usr/bin/mysqldump --defaults-file=/home/miusuario/.credenciales.cnf -u$user -p$pass --lock-tables --databases"
Add Comment
Please, Sign In to add comment