Difference between revisions of "User talk:Stephdl"
From SME Server
Jump to navigationJump to search| Line 6: | Line 6: | ||
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 | ||
Revision as of 20:50, 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
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
