5,576
edits
Changes
From SME Server
Jump to navigationJump to searchno edit summary
Line 39:
Line 39:
==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.. :)
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
−
