Биллинговая система Nodeny

#!/bin/sh 
passwd_root_mysql='hardpass' 
fl=`date "+%d-%m-%Y"` 
cd /usr/local/nodeny 
echo show tables | mysql -u root \ 
  --password=${passwd_root_mysql} bill | \ 
  grep -v '^[stuvxyz]2' | grep -v '^Tables' | \ 
  xargs mysqldump -Q --add-locks -u root \ 
  --password=${passwd_root_mysql} \ 
  --default-character-set=cp1251 bill $1 > bill_${fl}.sql 
tar -c -z -f ${fl}.tar.gz bill_${fl}.sql 
rm -f bill_${fl}.sql 
chmod 400 ${fl}.tar.gz

#!/bin/sh 
user_mysql='root' 
passwd_root_mysql='hardpass' 
host_mysql='localhost' 
fl=`date "+%d-%m-%Y"` 
cd /home/backups/bill/ 
echo show tables | mysql -h ${host_mysql} -u ${user_mysql} --password=$ {passwd_root_mysql} bill | \ 
  grep -v '^[stuvxyz]2' | grep -v '^Tables' | \ 
  xargs mysqldump -Q --add-locks -h ${host_mysql} -u ${user_mysql} -- password=${passwd_root_mysql} \ 
  --default-character-set=cp1251 bill $1 > bill_${fl}.sql 
tar -c -z -f ${fl}.tar.gz bill_${fl}.sql 
rm -f bill_${fl}.sql 
chmod 400 ${fl}.tar.gz
 

#!/bin/sh
passwd_root_mysql='hardpass'
fl=`date "+%d-%m-%Y"`
cd /var/backups/
echo show tables | /usr/local/bin/mysql -u root --password=${passwd_root_mysql} bill | \
  grep -v '^[stuvxyz]2' | grep -v '^Tables' | \
  xargs /usr/local/bin/mysqldump -Q --add-locks -u root --password=${passwd_root_mysql} \
  --default-character-set=cp1251 bill $1 > bill_${fl}.sql
tar -c -z -f ${fl}.tar.gz bill_${fl}.sql
rm -f bill_${fl}.sql
chmod 400 ${fl}.tar.gz

#!/bin/sh
passwd_root_mysql='hardpass'
mysql_cmd='/usr/local/bin/mysql'
mysqldump_cmd='/usr/local/bin/mysqldump'

fl=`date "+%d-%m-%Y"`
cd /var/backups/
echo show tables | ${mysql_cmd} -u root --password=${passwd_root_mysql} bill | \
  grep -v '^[stuvxyz]2' | grep -v 'traf_info' | grep -v '^Tables' | \
  xargs ${mysqldump_cmd} -Q --add-locks -u root --password=${passwd_root_mysql} \
  --default-character-set=cp1251 bill $1 > bill_${fl}.sql
tar -c -z -f ${fl}.tar.gz bill_${fl}.sql
rm -f bill_${fl}.sql
chmod 400 ${fl}.tar.gz

#!/bin/sh 
user_mysql='root' 
passwd_root_mysql='hardpass' 
host_mysql='localhost' 
fl=`date "+%d-%m-%Y"` 
cd /home/backups/bill/ 
echo show tables | mysql -h ${host_mysql} -u ${user_mysql} --password=$ {passwd_root_mysql} bill | \ 
  grep -v '^[stuvxyz]2' | grep -v '^Tables' | \ 
  xargs mysqldump -Q --add-locks -h ${host_mysql} -u ${user_mysql} -- password=${passwd_root_mysql} \ 
  --default-character-set=cp1251 bill $1 > bill_${fl}.sql 
tar -c -z -f ${fl}.tar.gz bill_${fl}.sql 
rm -f bill_${fl}.sql 
chmod 400 ${fl}.tar.gz

#!/bin/sh
PATH=/etc:/bin:/sbin:/usr/bin:/usr/sbin
passwd_root_mysql=`perl -e'require "/usr/local/nodeny/history.nod"; print $sql_root_pass;'`
mysql_cmd='/usr/local/bin/mysql'
mysqldump_cmd='/usr/local/bin/mysqldump'

fl=`date "+%d-%m-%Y"`
cd /var/backups/
echo show tables | ${mysql_cmd} -u root --password=${passwd_root_mysql} bill | \
  grep -v '^[stuvxyz]2' | grep -v 'traf_info' | grep -v '^Tables' | \
  xargs ${mysqldump_cmd} -R -Q --add-locks -u root --password=${passwd_root_mysql} \
  --default-character-set=cp1251 bill $1 > bill_${fl}.sql
tar -c -z -f ${fl}.tar.gz bill_${fl}.sql
rm -f bill_${fl}.sql
chmod 400 ${fl}.tar.gz

#!/bin/sh
PATH=/etc:/bin:/sbin:/usr/bin:/usr/sbin
passwd_root_mysql=`perl -e'require "/usr/local/nodeny/history.nod"; print $sql_root_pass;'`
mysql_cmd='/usr/local/bin/mysql'
mysqldump_cmd='/usr/local/bin/mysqldump'

fl=`date "+%d-%m-%Y"`
cd /var/backups/
echo show tables | ${mysql_cmd} -u root --password=${passwd_root_mysql} bill | \
  grep -v '^[stuvxyz]2' | grep -v 'traf_info' | grep -v '^Tables' | \
  xargs ${mysqldump_cmd} -R -Q --add-locks -u root --password=${passwd_root_mysql} \
  --default-character-set=cp1251 bill $1 > bill_${fl}.sql
tar -c -z -f ${fl}.tar.gz bill_${fl}.sql
rm -f bill_${fl}.sql
chmod 400 ${fl}.tar.gz

#!/bin/sh
PATH=/etc:/bin:/sbin:/usr/bin:/usr/sbin
passwd_root_mysql=`perl -e'require "/usr/local/nodeny/history.nod"; $sql_root_pass=~s/(.)/\\\\$1/g; print $sql_root_pass;'`
mysql_cmd='/usr/local/bin/mysql'
mysqldump_cmd='/usr/local/bin/mysqldump'

fl=`date "+%d-%m-%Y"`
cd /var/backups/
echo echo show tables \| ${mysql_cmd} -u root --password=${passwd_root_mysql} bill \| \
  grep -v '^[stuvxyz]2' \| grep -v 'traf_info' \| grep -v '^Tables' \| \
  xargs ${mysqldump_cmd} -R -Q --add-locks -u root --password=${passwd_root_mysql} \
  --default-character-set=cp1251 bill \$1 \> bill_${fl}.sql > /tmp/tmpbackup
sh /tmp/tmpbackup
tar -c -z -f ${fl}.tar.gz bill_${fl}.sql
rm -f bill_${fl}.sql
chmod 400 ${fl}.tar.gz

#!/bin/sh
PATH=/etc:/bin:/sbin:/usr/bin:/usr/sbin
passwd_root_mysql=`perl -e'require "/usr/local/nodeny/history.nod"; $sql_root_pass=~s/(.)/\\\\$1/g; print $sql_root_pass;'`
mysql_cmd=`which mysql` || '/usr/local/bin/mysql'
mysqldump_cmd=`which mysqldump` || '/usr/local/bin/mysqldump'

fl=`date "+%d-%m-%Y"`
cd /var/backups/
echo echo show tables \| ${mysql_cmd} -u root --password=${passwd_root_mysql} bill \| \
  grep -v '^[stuvxyz]2' \| grep -v 'traf_info' \| grep -v '^Tables' \| \
  xargs ${mysqldump_cmd} -R -Q --add-locks -u root --password=${passwd_root_mysql} \
  --default-character-set=cp1251 bill \$1 \> bill_${fl}.sql > /tmp/tmpbackup
sh /tmp/tmpbackup
rm /tmp/tmpbackup
tar -c -z -f ${fl}.tar.gz bill_${fl}.sql
rm -f bill_${fl}.sql
chmod 400 ${fl}.tar.gz

#!/bin/bash
DROPBOX_USER="Your Dropbox username"
DROPBOX_PASS="Your Dropbox password"
DROPBOX_DIR="Directory in your dropbox account to store the backups, e.g. /backups"
BACKUP_SRC="/home /var/www /var/git /etc /root"
BACKUP_DST="/tmp"
MYSQL_SERVER="127.0.0.1"
MYSQL_USER="root"
MYSQL_PASS="Your MySQL password"

#
# Stop editing here.
NOW=$(date +"%Y.%m.%d")
DESTFILE="$BACKUP_DST/$NOW.tgz"

#
# Upload a file to Dropbox.
# $1 = Source file
# $2 = Destination file.
function dropboxUpload
{
	#
	# Code based on DropBox Uploader 0.6 from http://www.andreafabrizi.it/?dropbox_uploader
	LOGIN_URL="https://www.dropbox.com/login"
	HOME_URL="https://www.dropbox.com/home"
	UPLOAD_URL="https://dl-web.dropbox.com/upload"
	COOKIE_FILE="/tmp/du_cookie_$RANDOM"
	RESPONSE_FILE="/tmp/du_resp_$RANDOM"

    UPLOAD_FILE=$1
    DEST_FOLDER=$2

	# Login
	echo -ne " > Logging in..."
	curl -s -i -c $COOKIE_FILE -o $RESPONSE_FILE --data "login_email=$DROPBOX_USER&login_password=$DROPBOX_PASS&t=$TOKEN" "$LOGIN_URL"
	grep "location: /home" $RESPONSE_FILE > /dev/null

	if [ $? -ne 0 ]; then
		echo -e " Failed!"
		rm -f "$COOKIE_FILE" "$RESPONSE_FILE"
		exit 1
	else
		echo -e " OK"
	fi

	# Load home page
	echo -ne " > Loading Home..."
	curl -s -i -b "$COOKIE_FILE" -o "$RESPONSE_FILE" "$HOME_URL"

	if [ $? -ne 0 ]; then
		echo -e " Failed!"
		rm -f "$COOKIE_FILE" "$RESPONSE_FILE"
		exit 1
	else
		echo -e " OK"
	fi

	# Get token
	TOKEN=$(cat "$RESPONSE_FILE" | tr -d '\n' | sed 's/.*<form action="https:\/\/dl-web.dropbox.com\/upload"[^>]*>\s*<input type="hidden" name="t" value="\([a-z 0-9]*\)".*/\1/')

	# Upload file
	echo -ne " > Uploading '$UPLOAD_FILE' to 'DROPBOX$DEST_FOLDER/'..."
    curl -s -i -b $COOKIE_FILE -o $RESPONSE_FILE -F "plain=yes" -F "dest=$DEST_FOLDER" -F "t=$TOKEN" -F "file=@$UPLOAD_FILE"  "$UPLOAD_URL"
    grep "HTTP/1.1 302 FOUND" "$RESPONSE_FILE" > /dev/null

    if [ $? -ne 0 ]; then
        echo -e " Failed!"
		rm -f "$COOKIE_FILE" "$RESPONSE_FILE"
        exit 1
    else
        echo -e " OK"
		rm -f "$COOKIE_FILE" "$RESPONSE_FILE"
    fi
}

# Backup files.
mysqldump -u $MYSQL_USER -h $MYSQL_SERVER -p$MYSQL_PASS --all-databases > "$NOW-Databases.sql"
tar cfz "$DESTFILE" $BACKUP_SRC "$NOW-Databases.sql"

dropboxUpload "$DESTFILE" "$DROPBOX_DIR"

rm -f "$NOW-Databases.sql" "$DESTFILE"

alfa# sh test.sh
function: not found
-ne  > Logging in...
 OK
-ne  > Loading Home...
 OK
-ne  > Uploading '' to 'DROPBOX/'...
 Failed!
alfa#

alfa# ~/.dropbox-dist/dropboxd &
[1] 36245
alfa# readlink: illegal option -- f
usage: readlink [-n] [file ...]
usage: dirname string [...]
exec: /dropbox: not found

cd /usr/ports/lang/python25
 make install clean
 cd /usr/bin
 ln -s /usr/local/bin/python2.5 python

#!/bin/sh
n="dneprolan"
DIR=/home/maks/backup/dneprolan
DATA=`date '+%d.%m.%Y'`
name="backup_${n}_${DATA}"
sb="test.dyndns.tv"
l="root"
cd /root
mysql -u root bill -phardpass < /root/traf_lost.sql
cd /
mysqldump -u root --password='hardpass' -l --all-databases | gzip > db-$DATA.sql.gz
cd $DIR
tar czvf $DIR/$name.tar.gz --exclude='usr/local/www/apache22/data/video/images/*' --exclude='usr/local/www/apache22/data/video/video/images/*'  /etc/* /usr/local/etc/* /var/cron/* /boot/loader.conf /usr/local/www/* /var/named/* /usr/local/nodeny/* /db-$DATA.sql.gz
rm /db-$DATA.sql.gz
scp -P 212 $DIR/$name.tar.gz $l@$sb:$DIR/$name.tar.gz
find $DIR/* -mtime +10 -exec rm {} \;
ssh test.dyndns.tv -p 2222 -l root 'find /home/maks/backup/dneprolan/* -mtime +10 -exec rm {} \;'
exit

INSERT INTO `users` VALUES (1,'user1','
                                        x^W     ▒@▒&c(▒t');

INSERT INTO `users` VALUES (1,'user1',0x1B8409785E57091CA240D7266328DB74);

#!/bin/sh 
user_mysql='root' 
passwd_root_mysql='hardpass' 
host_mysql='localhost' 
fl=`date "+%d-%m-%Y"` 
cd /home/backups/bill/ 
echo show tables | mysql -h ${host_mysql} -u ${user_mysql} --password=$ {passwd_root_mysql} bill | \ 
  grep -v '^[stuvxyz]2' | grep -v '^Tables' | \ 
  xargs mysqldump -Q --add-locks -h ${host_mysql} -u ${user_mysql} -- password=$ {passwd_root_mysql} \ 
  --default-character-set=cp1251 bill $1 > bill_${fl}.sql 
tar -c -z -f ${fl}.tar.gz bill_${fl}.sql 
rm -f bill_${fl}.sql 
chmod 400 ${fl}.tar.gz
 

mysql -h yourdomain -u mylogin_user -p mylogin_db

xargs: unterminated quote