5,576
edits
Changes
From SME Server
Jump to navigationJump to searchno edit summary
db accounts setprop toto Indexes disabled
db accounts setprop toto Indexes disabled
signal-event ibay-modify toto
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
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}"`
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
