[Script] Automatic backup bases
#1

In total hello,
In general the purpose of a script such is to do ôðüÿ all bases at:
1) Emergency server shutdown at DOS attacks!
2) At server reset!
3) At full of a server stop Devom!
 
As a whole the script will be useful to much, BUT NOT the Script checked

 

#!/bin/sh

DBHOST=localhost
USER=
PASS=
DBNAME_1=newproject_data
DBNAME_2=newproject_db
DBNAME_3=newproject_db_auth

while :;
do
mysqlcheck -h $DBHOST -u $USER --password=$PASS -s -r $DBNAME_1>>"log/`date +%Y-%m-%d_%H:%M:%S`-sql_newproject_data.log"
mysqlcheck -h $DBHOST -u $USER --password=$PASS -s -r $DBNAME_2>>"log/`date +%Y-%m-%d_%H:%M:%S`-sql_newproject_db.log"
mysqlcheck -h $DBHOST -u $USER --password=$PASS -s -r $DBNAME_3>>"log/`date +%Y-%m-%d_%H:%M:%S`-sql_newproject_db_auth.log"
mysqldump -h $DBHOST -u $USER --password=$PASS $DBNAME_1 | gzip > "backup/`date +%Y-%m-%d_%H:%M:%S`-"$DBNAME"_newproject_data.gz"
mysqldump -h $DBHOST -u $USER --password=$PASS $DBNAME_2 | gzip > "backup/`date +%Y-%m-%d_%H:%M:%S`-"$DBNAME"_newproject_db.gz"
mysqldump -h $DBHOST -u $USER --password=$PASS $DBNAME_3 | gzip > "backup/`date +%Y-%m-%d_%H:%M:%S`-"$DBNAME"_newproject_db_auth.gz"

cd Connector/Connector;
./start;
sleep 5;

cd ../../;
cd Helper/Helper;
./start;
sleep 5;

cd ../../;
cd SubHelper/SubHelper;
./start;
sleep 5;

cd ../../;
cd Messenger/Messenger;
./start;
sleep 5;

cd ../../;
cd GameServer;

cd GameServer1;
./start2;
cd ..;

cd GameServer2;
./start2;
cd ..;

cd GameServer3;
./start2;
cd ..;

cd GameServer4;
./start2;
cd ..;

cd GameServer5;
./start2;

cd ../../;
cd LoginServer/LoginServer;
./start;

[ $? -ne 2 ] && break
sleep 30;
done

 

 

! ! ! IMPORTANT! ! !

In the root folder of the server we create folders with the name log and backup for this purpose to leave information about backup and the arisen mistakes at Tampa.
 
The folder - log = Serves for the reporting about backup
The folder - backup = Serves for preservation backup
 
I hope a script it will be useful to you, from you a magic button like with you there was your Warface
#2
dont is more easy make a event in mysql *-* ?

#3
all we would need is a linux navicat premimum or mysql key.. and iam seariching for it like ages

#4

Why not just use HeidiSQL instead of navicat?

 

And to make a database backup i prefer to make a cronjob, auto backup every xx hours and upload the backup to a external server

 

 

backup.sh

BACKUPFILE=/home/backup/MySQLDB_`date +%Y-%m-%d-%H`.sql.gz
mysqldump -u root -pPASSWORDHERE --databases newproject_auth newproject_db newproject_web | gzip > $BACKUPFILE

export SSHPASS=SSHPASSWORDFROMEXTERNALSERVERHERE

sshpass -e sftp -oBatchMode=no -b - IPADDRESSOFEXTERNALSERVER << !
put $BACKUPFILE
bye
!

#5

all we would need is a linux navicat premimum or mysql key.. and iam seariching for it like ages

In my forum we got navicat for Linux + working key for registration^^ If you need, pm

#6

you can also use "mysqldumper" with cronjob...

 

upload to a ftp-server and sending per email, full automatically...  its very nice^^

#7

In my forum we got navicat for Linux + working key for registration^^ If you need, pm

PM if u got time i guess your inbox is full so I am unable to send u any massages



Forum Jump:


Users browsing this thread: 1 Guest(s)