Diferencia entre revisiones de «MySQL»

De gacq wiki
Saltar a: navegación, buscar
(Hot backup - All databases)
(Hot backup - One database)
Línea 28: Línea 28:
 
  # by gacq
 
  # by gacq
 
  #
 
  #
# MySQL root password
 
 
  PASSWORD=$1
 
  PASSWORD=$1
 
  DATABASE=$2
 
  DATABASE=$2
 +
OUTPUTDIR="/srv/backup/mysql"
 
   
 
   
 
  # Delete backups older than the number of days specified in DAYS
 
  # Delete backups older than the number of days specified in DAYS
 
  DAYS=8
 
  DAYS=8
 
OUTPUTDIR="/srv/backup/mysql"
 
 
   
 
   
 
  date=`date +%F_%T | tr \: _`
 
  date=`date +%F_%T | tr \: _`
  mysqldump --password=$PASSWORD $DATABASE | gzip > $DATABASE-${date}.sql.gz
+
  mysqldump --password=$PASSWORD $DATABASE | gzip > $OUTPUTDIR/$DATABASE-${date}.sql.gz
 
   
 
   
 
  # Delete older backups
 
  # Delete older backups
 
  find $OUTPUTDIR -type f -name "all-databases.*.sql" -ctime $DAYS -exec rm -f {} \;
 
  find $OUTPUTDIR -type f -name "all-databases.*.sql" -ctime $DAYS -exec rm -f {} \;

Revisión del 19:57 11 sep 2006

Tools

  • PHPMyAdmin

Common task

Change password

set password = password("yournewpassword");

Scripts

Hot backup - All databases

#!/bin/sh
# by gacq
#
# MySQL root password
PASSWORD=$1
OUTPUTDIR="/srv/backup/mysql"

# Delete backups older than the number of days specified in DAYS
DAYS=8

date=`date +%F_%T | tr \: _`
mysqldump --all-databases --password=$PASSWORD | gzip > $OUTPUTDIR/all-databases-${date}.sql.gz

# Delete older backups
find $OUTPUTDIR -type f -name "all-databases.*.sql" -ctime $DAYS -exec rm -f {} \;

Hot backup - One database

#!/bin/sh
# by gacq
#
PASSWORD=$1
DATABASE=$2
OUTPUTDIR="/srv/backup/mysql"

# Delete backups older than the number of days specified in DAYS
DAYS=8

date=`date +%F_%T | tr \: _`
mysqldump --password=$PASSWORD $DATABASE | gzip > $OUTPUTDIR/$DATABASE-${date}.sql.gz

# Delete older backups
find $OUTPUTDIR -type f -name "all-databases.*.sql" -ctime $DAYS -exec rm -f {} \;