Difference between revisions of "User talk:Stephdl"

From SME Server
Jump to navigationJump to search
Line 40: Line 40:
  
 
  chmod +x /etc/cron.daily/runmysqlbackup
 
  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
 
  automysqlbackup /etc/automysqlbackup/myserver.conf
Line 53: Line 62:
 
nano /usr/local/bin/automysqlbackup  
 
nano /usr/local/bin/automysqlbackup  
 
   echo `du -hs --si "${CONFIG_backup_dir}"`
 
   echo `du -hs --si "${CONFIG_backup_dir}"`
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
 

Revision as of 19:52, 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

history

wget http://sourceforge.net/projects/automysqlbackup/files/latest/download
tar xvf automysqlbackup-v3.0_rc6.tar.gz 
 139  ls
 140  ls -la
 141  less README 
 142  less install.sh
 143  less automysqlbackup.conf 
 144  less README 
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}"`