Difference between revisions of "User talk:Stephdl"
From SME Server
Jump to navigationJump to searchLine 9: | Line 9: | ||
==automysqlbackup== | ==automysqlbackup== | ||
i'm testing, not ready yet | i'm testing, not ready yet | ||
− | === | + | ===starting=== |
wget http://sourceforge.net/projects/automysqlbackup/files/latest/download | wget http://sourceforge.net/projects/automysqlbackup/files/latest/download | ||
tar xvf automysqlbackup-v3.0_rc6.tar.gz | tar xvf automysqlbackup-v3.0_rc6.tar.gz | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
mkdir /etc/automysqlbackup | mkdir /etc/automysqlbackup |
Revision as of 19:53, 8 April 2013
http://wiki.contribs.org/SME_Server:Documentation:QA:Verification
- ajouter un utilisateur
db accounts setprop toto Shell /bin/bash signal-event user-modify toto
- empecher indexer repertoire
db accounts setprop toto Indexes disabled signal-event ibay-modify toto
automysqlbackup
i'm testing, not ready yet
starting
wget http://sourceforge.net/projects/automysqlbackup/files/latest/download tar xvf automysqlbackup-v3.0_rc6.tar.gz
mkdir /etc/automysqlbackup mv automysqlbackup.conf /etc/automysqlbackup mv automysqlbackup /usr/local/bin chmod +x /usr/local/bin/automysqlbackup mkdir /var/backup cp /etc/automysqlbackup/automysqlbackup.conf /etc/automysqlbackup/myserver.conf nano /etc/automysqlbackup/myserver.conf
nano /etc/cron.daily/runmysqlbackup
#!/bin/sh /usr/local/bin/automysqlbackup /etc/automysqlbackup/myserver.conf chown root.root /var/backup/db* -R find /var/backup/db* -type f -exec chmod 400 {} \; find /var/backup/db* -type d -exec chmod 700 {} \;
chmod +x /etc/cron.daily/runmysqlbackup
modification myserver.conf
nano /etc/automysqlbackup/myserver.conf
CONFIG_mysql_dump_username='root' CONFIG_mysql_dump_password='your password'
your mysql password is in the file /root/.my.cnf
automysqlbackup /etc/automysqlbackup/myserver.conf
you can have this error
###### WARNING ###### Errors reported during AutoMySQLBackup execution.. Backup failed Error log below.. du: WARNING: use --si, not -H; the meaning of the -H option will soon change to be the same as that of --dereference-args (-D)
nano /usr/local/bin/automysqlbackup
echo `du -hs --si "${CONFIG_backup_dir}"`