Sv translation

language	en

Status

colour	Red
title	DEPRICATED

Create MySQL-

Backup anlegen (Nur einer der Master)

Backup (Only one of the Masters)

The MySQL backup is created on the master server. The server performs daily backup and deletes all files older than 7 days.

Simply copy the following into the command line as root and execute it - replace <password> with the corresponding password:

Translations Ignore

Auf dem Master Server wird das MySQL-Backup angelegt. Der Server führt täglich das Backup aus und löscht alle Dateien, die älter als 7 Tage sind.

Dazu einfach folgendes in die Kommandozeile als root kopieren und ausführen - <password> mit den entsprechenden Passwort ersetzen:

Code Block

language	bash

CONFIG_mysql_dump_username='root'
CONFIG_mysql_dump_password='<password>'
CONFIG_backup_dir='/home/jtel/shared/backup/sql'
CONFIG_mysql_dump_host='localhost'
URI="http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%203.0/automysqlbackup-v3.0_rc6.tar.gz"



cd /home/jtel
mkdir -p /home/jtel/automysqlbackup
mkdir -p ${CONFIG_backup_dir}
chown -R jtel:jtel /home/jtel/automysqlbackup
chown -R jtel:jtel /home/jtel/shared/backup

cd /home/jtel/automysqlbackup

curl -O -L ${URI}
tar xfvz ${URI##*/}

cp automysqlbackup.conf automysqlbackup.conf.orig
cp automysqlbackup automysqlbackup.orig


# remove parameter '--password' to fall back to .my.cnf
sed -i -e 's/--password="${CONFIG_mysql_dump_password}" //' automysqlbackup

cat << EOF > /home/jtel/.my.cnf
[client]
user = ${CONFIG_mysql_dump_username}
password = ${CONFIG_mysql_dump_password}
host = ${CONFIG_mysql_dump_host}
EOF
cat /home/jtel/.my.cnf


chown -R jtel:jtel /home/jtel/.my.cnf

cat << EOF > automysqlbackup.conf
CONFIG_mysql_dump_username="${CONFIG_mysql_dump_username}"
CONFIG_mysql_dump_password="${CONFIG_mysql_dump_password}"
CONFIG_mysql_dump_host="${CONFIG_mysql_dump_host}"
CONFIG_backup_dir="${CONFIG_backup_dir}"

# Include CREATE DATABASE in backup?
CONFIG_mysql_dump_create_database='yes'

# Separate backup directory and file for each DB? (yes or no)
CONFIG_mysql_dump_use_separate_dirs='no'

# Master Data
CONFIG_mysql_dump_master_data=2

# Single Transaction
CONFIG_mysql_dump_single_transaction='yes'

# List of databases for Daily/Weekly Backup e.g. ( 'DB1' 'DB2' 'DB3' ... )
# set to (), i.e. empty, if you want to backup all databases
#CONFIG_db_names=()

# List of databases for Monthly Backups.
# set to (), i.e. empty, if you want to backup all databases
#CONFIG_db_month_names=()

# List of DBNAMES to EXLUCDE if DBNAMES is empty, i.e. ().
CONFIG_db_exclude=( 'information_schema' 'performance_schema' )

# Include routines
CONFIG_mysql_dump_full_schema='yes'

# Rotation Settings

# Which day do you want monthly backups? (01 to 31)
# If the chosen day is greater than the last day of the month, it will be done
# on the last day of the month.
# Set to 0 to disable monthly backups.
#CONFIG_do_monthly="01"

# Which day do you want weekly backups? (1 to 7 where 1 is Monday)
# Set to 0 to disable weekly backups.
#CONFIG_do_weekly="5"

# Set rotation of daily backups. VALUE*24hours
# If you want to keep only today's backups, you could choose 1, i.e. everything older than 24hours will be removed.
#CONFIG_rotation_daily=6

# Set rotation for weekly backups. VALUE*24hours
#CONFIG_rotation_weekly=35

# Set rotation for monthly backups. VALUE*24hours
#CONFIG_rotation_monthly=150


# No SSL Connection to server
CONFIG_mysql_dump_usessl='no'
EOF


/home/jtel/automysqlbackup/automysqlbackup /home/jtel/automysqlbackup/automysqlbackup.conf
 
cat << 'EOF' > automysqlbackup.cron
#!/bin/bash
su - jtel -c '/home/jtel/automysqlbackup/automysqlbackup /home/jtel/automysqlbackup/automysqlbackup.conf'
EOF

chmod 750 automysqlbackup.cron
sudo ln -s /home/jtel/automysqlbackup/automysqlbackup.cron /etc/cron.daily
chown -R jtel:jtel /home/jtel/automysqlbackup
chown -R jtel:jtel /home/jtel/shared/backup

Sv translation

language	de

Status

colour	Red
title	DEPRICATED

MySQL-Backup anlegen (Nur einer der Master)

Auf dem Master Server wird das MySQL-Backup angelegt. Der Server führt täglich das Backup aus und löscht alle Dateien, die älter als 7 Tage sind.

Dazu einfach folgendes in die Kommandozeile als root kopieren und ausführen - <password>

mit den entsprechenden Passwort ersetzen:

Translations Ignore

Code Block

language	bash

CONFIG_mysql_dump_username='root'
CONFIG_mysql_dump_password='<password>'
CONFIG_backup_dir='/home/jtel/shared/backup/sql'
CONFIG_mysql_dump_host='localhost'
URI="http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%203.0/automysqlbackup-v3.0_rc6.tar.gz"



cd /home/jtel
mkdir -p /home/jtel/automysqlbackup
mkdir -p ${CONFIG_backup_dir}
chown -R jtel:jtel /home/jtel/automysqlbackup
chown -R jtel:jtel /home/jtel/shared/backup

cd /home/jtel/automysqlbackup

curl -O -L ${URI}
tar xfvz ${URI##*/}

cp automysqlbackup.conf automysqlbackup.conf.orig
cp automysqlbackup automysqlbackup.orig


# remove parameter '--password' to fall back to .my.cnf
sed -i -e 's/--password="${CONFIG_mysql_dump_password}" //' automysqlbackup

cat << EOF > /home/jtel/.my.cnf
[client]
user = ${CONFIG_mysql_dump_username}
password = ${CONFIG_mysql_dump_password}
host = ${CONFIG_mysql_dump_host}
EOF
cat /home/jtel/.my.cnf


chown -R jtel:jtel /home/jtel/.my.cnf

cat << EOF > automysqlbackup.conf
CONFIG_mysql_dump_username="${CONFIG_mysql_dump_username}"
CONFIG_mysql_dump_password="${CONFIG_mysql_dump_password}"
CONFIG_mysql_dump_host="${CONFIG_mysql_dump_host}"
CONFIG_backup_dir="${CONFIG_backup_dir}"

# Include CREATE DATABASE in backup?
CONFIG_mysql_dump_create_database='yes'

# Separate backup directory and file for each DB? (yes or no)
CONFIG_mysql_dump_use_separate_dirs='no'

# Master Data
CONFIG_mysql_dump_master_data=2

# Single Transaction
CONFIG_mysql_dump_single_transaction='yes'

# List of databases for Daily/Weekly Backup e.g. ( 'DB1' 'DB2' 'DB3' ... )
# set to (), i.e. empty, if you want to backup all databases
#CONFIG_db_names=()

# List of databases for Monthly Backups.
# set to (), i.e. empty, if you want to backup all databases
#CONFIG_db_month_names=()

# List of DBNAMES to EXLUCDE if DBNAMES is empty, i.e. ().
CONFIG_db_exclude=( 'information_schema' 'performance_schema' )

# Include routines
CONFIG_mysql_dump_full_schema='yes'

# Rotation Settings

# Which day do you want monthly backups? (01 to 31)
# If the chosen day is greater than the last day of the month, it will be done
# on the last day of the month.
# Set to 0 to disable monthly backups.
#CONFIG_do_monthly="01"

# Which day do you want weekly backups? (1 to 7 where 1 is Monday)
# Set to 0 to disable weekly backups.
#CONFIG_do_weekly="5"

# Set rotation of daily backups. VALUE*24hours
# If you want to keep only today's backups, you could choose 1, i.e. everything older than 24hours will be removed.
#CONFIG_rotation_daily=6

# Set rotation for weekly backups. VALUE*24hours
#CONFIG_rotation_weekly=35

# Set rotation for monthly backups. VALUE*24hours
#CONFIG_rotation_monthly=150


# No SSL Connection to server
CONFIG_mysql_dump_usessl='no'
EOF


/home/jtel/automysqlbackup/automysqlbackup /home/jtel/automysqlbackup/automysqlbackup.conf
 
cat << 'EOF' > automysqlbackup.cron
#!/bin/bash
su - jtel -c '/home/jtel/automysqlbackup/automysqlbackup /home/jtel/automysqlbackup/automysqlbackup.conf'
EOF

chmod 750 automysqlbackup.cron
sudo ln -s /home/jtel/automysqlbackup/automysqlbackup.cron /etc/cron.daily
chown -R jtel:jtel /home/jtel/automysqlbackup
chown -R jtel:jtel /home/jtel/shared/backup

Sv translation

language	fr

Status

colour	Red
title	DEPRIS

Créer une Sauvegarde -MySQL (un seul des Maîtres)

La sauvegarde MySQL est créée sur le serveur maître. Le serveur effectue une sauvegarde quotidienne et supprime tous les fichiers de plus de 7 jours.

Copiez simplement ce qui suit dans la ligne de commande en tant que root et exécutez-le - remplacez <password> par le mot de passe correspondant :

Translations Ignore

Code Block

language	bash

CONFIG_mysql_dump_username='root'

 CONFIG_mysql_dump_password='<password>'

 CONFIG_backup_dir='/home/jtel/shared/backup/sql'

 CONFIG_mysql_dump_host='localhost'

 URI="http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%203.0/automysqlbackup-v3.0_rc6.tar.gz"

 cd /home/jtel

 mkdir -p /home/jtel/automysqlbackup

 mkdir -p ${CONFIG_backup_dir}

 chown -R jtel:jtel /home/jtel/automysqlbackup

 chown -R jtel:jtel /home/jtel/shared/backup

 cd /home/jtel/automysqlbackup

 curl -O -L ${URI}

 tar xfvz ${URI##*/}

 cp automysqlbackup.conf automysqlbackup.conf.orig

 cp automysqlbackup automysqlbackup.orig

 # remove parameter '--password' to fall back to .my.cnf

 sed -i -e 's/--password="${CONFIG_mysql_dump_password}" //' automysqlbackup

 cat << EOF > /home/jtel/.my.cnf

 [client]

 user = ${CONFIG_mysql_dump_username}

 password = ${CONFIG_mysql_dump_password}

 host = ${CONFIG_mysql_dump_host}

EOF

 cat /home/jtel/.my.cnf

 chown -R jtel:jtel /home/jtel/.my.cnf

 cat << EOF > automysqlbackup.conf

 CONFIG_mysql_dump_username="${CONFIG_mysql_dump_username}"

 CONFIG_mysql_dump_password="${CONFIG_mysql_dump_password}"

 CONFIG_mysql_dump_host="${CONFIG_mysql_dump_host}"

 CONFIG_backup_dir="${CONFIG_backup_dir}"

 # Include CREATE DATABASE in backup?

 CONFIG_mysql_dump_create_database='yes'

# Separate backup directory and file for each DB? (yes or no)

 # Répertoire et fichier de sauvegarde séparés pour chaque BD ? (oui ou non) CONFIG_mysql_dump_use_separate_dirs= '

no

non'

 # Données

Master

de base

Data

CONFIG_mysql_dump_master_data=2

 # Transaction

Single

unique

Transaction

CONFIG_mysql_dump_single_transaction= '

yes

oui'

# List of databases for Daily/Weekly Backup e.

 # Liste des bases de données pour la sauvegarde quotidienne/hebdomadaire e. g. (

'DB1' 'DB2' 'DB3' ... )

set

défini

to

à (),

i.e. empty, if you want to backup all databases

c'est-à-dire vide, si vous voulez sauvegarder toutes les bases de données #CONFIG_db_names=()

List of databases for Monthly Backups. # set to

Liste des bases de données pour les sauvegardes mensuelles. # défini à (),

i.e. empty, if you want to backup all databases

 c'est à dire vide, si vous voulez sauvegarder toutes les bases de données #CONFIG_db_month_names=()

List

Liste

of

des DBNAMES

to

à EXLUCDE

if

si DBNAMES

is

est

empty

vide,

i.e.

 c'est à dire ().

 CONFIG_db_exclude=( 'information_schema' 'performance_schema' )

 # Include routines

 CONFIG_mysql_dump_full_schema='yes'

 # Rotation Settings

 # Which day do you want monthly backups? (01

to

à 31)

If

Si

the

le

chosen

jour

day

choisi

is

est

greater

supérieur

than

au

the

dernier

last

jour

day of the month

du mois,

it

il

will

sera

be

fait

done

on the

last

le

day

dernier

of

jour

the

du

month

mois.

Set

Mettre

to

à 0 pour

to

désactiver

disable

les

monthly

sauvegardes

backups

mensuelles.

 #CONFIG_do_monthly="01"

Which

Quel

day

jour

do

voulez-vous

you

des

want

sauvegardes

weekly

hebdomadaires

backups

? (1

to

à 7

where

où 1 est

is

le

Monday

lundi)

Set

Mettre

to

à 0 pour

to

désactiver

disable

les

weekly

sauvegardes

backups

hebdomadaires.

 #CONFIG_do_weekly="5"

 # Régler

Set

la rotation

of

des

daily

sauvegardes

backups

quotidiennes.

VALUE

VALEUR*

24hours # If you want to keep only today's backups, you could choose 1, i.e. everything older than 24hours will be removed.

24heures # Si vous souhaitez ne conserver que les sauvegardes d'aujourd'hui, vous pouvez en choisir une, c'est-à-dire que tout ce qui a plus de 24 heures sera supprimé. #CONFIG_rotation_daily=6

Set

Définir la rotation pour

for

les

weekly

sauvegardes

backups

hebdomadaires. VALUE*24hours

 #CONFIG_rotation_weekly=35

Set

Définir la rotation pour

for

les

monthly

sauvegardes

backups

mensuelles. VALUE*24hours

 #CONFIG_rotation_monthly=150

 # No SSL Connection to server

 CONFIG_mysql_dump_usessl='no'

EOF

 /home/jtel/automysqlbackup/automysqlbackup /home/jtel/automysqlbackup/automysqlbackup.conf

 cat << 'EOF' > automysqlbackup.cron

 #!/bin/bash

 su - jtel -c '/home/jtel/automysqlbackup/automysqlbackup /home/jtel/automysqlbackup/automysqlbackup.conf'

EOF

 chmod 750 automysqlbackup.cron

 sudo ln -s /home/jtel/automysqlbackup/automysqlbackup.cron /etc/cron.daily

 chown -R jtel:jtel /home/jtel/automysqlbackup

 chown -R jtel:jtel /home/jtel/shared/backup

Page tree

Versions Compared

Old Version 14

New Version Current

Key

Create MySQL-

Backup (Only one of the Masters)

MySQL-Backup anlegen (Nur einer der Master)

Créer une Sauvegarde -MySQL (un seul des Maîtres)

Page tree

Page History

Versions Compared

Old Version 14

New Version Current

Key

Create MySQL-

Backup (Only one of the Masters)

MySQL-Backup anlegen (Nur einer der Master)

Créer une Sauvegarde -MySQL (un seul des Maîtres)