| Line 39: |
Line 39: |
| | smeserver-qos daniel | | smeserver-qos daniel |
| | smeserver-htbwshaper | | smeserver-htbwshaper |
| | + | * temp Folder for php |
| | + | mkdir /etc/e-smith/templates-custom/etc/php.ini/ |
| | + | nano /etc/e-smith/templates-custom/etc/php.ini/12phptmpfolder |
| | + | then paste this and save the file by ctrl+x |
| | + | |
| | + | upload_tmp_dir = /tmp |
| | + | |
| | + | and then do |
| | + | signal-event console-save |
| | | | |
| | | | |
| Line 78: |
Line 87: |
| | mysql> QUIT; | | mysql> QUIT; |
| | Bye | | Bye |
| − |
| |
| − |
| |
| − | ==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
| |
| − |
| |
| − | CONFIG_db_names=()
| |
| − | CONFIG_db_month_names=()
| |
| − |
| |
| − | to launch the script
| |
| − |
| |
| − | automysqlbackup /etc/automysqlbackup/myserver.conf
| |
| − |
| |
| − | ===error with 'du' in the script===
| |
| − | 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)
| |
| − |
| |
| − | see lines 1972
| |
| − |
| |
| − | nano /usr/local/bin/automysqlbackup
| |
| − | echo `du -hs --si "${CONFIG_backup_dir}"`
| |
| − |
| |
| − |
| |
| − | # mysql --user=username --pass=password --host=dbserver database < /path/file.sql
| |
| − | # or
| |
| − | # mysql --user=username --pass=password --host=dbserver -e "source /path/file.sql" database
| |
| − | #
| |
| − | # NOTE: Make sure you use "<" and not ">" in the above command because
| |
| − | # you are piping the file.sql to mysql and not the other way around.
| |
| − | #
| |
| − | # Lets hope you never have to use this.. :)
| |
