If you are using a Windows server then I have two suggestions for you:Menuval wrote:Hello,
was wondering if there is any tool around that helps backing up server files/database ? like an automated schedueled one.
Thanks,
Code: Select all
/home/l2jserver/Code: Select all
/home/l2jserver/opt//home/l2jserver/build/Code: Select all
#!/bin/sh # backup last logs files (maybe you need to check this later..)cp -rf /home/l2jserver/gameserver/log/ /home/l2jserver/opt/ # backup for olympiad.properties to restore it after updatecp -rf /home/l2jserver/gameserver/config/olympiad.properties /home/l2jserver/build/ # backup crests clans to restore it after updatecp -rf /home/l2jserver/gameserver/data/crests/ /home/l2jserver/opt/ # I have some modifications in LoginServer_loop.sh and i want to save this file also (optional for me)cp -rf /home/l2jserver/login/LoginServer_loop.sh /home/l2jserver/build/ # And.. all you need# -- here -- # Now,.. clean all filesrm -rf /home/l2jserver/gameserverrm -rf /home/l2jserver/libsrm -rf /home/l2jserver/languagesrm -rf /home/l2jserver/loginrm -rf /home/l2jserver/sqlrm -rf /home/l2jserver/toolsrm -rf /home/l2jserver/docrm -rf /home/l2jserver/imagesrm -rf /home/l2jserver/configrm -rf /home/l2jserver/*.txtrm -rf /home/l2jserver/*_lIC*rm -rf /home/l2jserver/*.html #Well.. now we can extract our updated server in same placeunzip -o -q /home/l2jserver/build/L2J_Server.zip -d ..unzip -o -q /home/l2jserver/build/L2J_DataPack.zip -d .. #We need to restore our important info (geodata included)cp -rf /home/l2jserver/build/geodata /home/l2jserver/gameserver/datacp -rf /home/l2jserver/build/pathnode /home/l2jserver/gameserver/datacp -rf /home/l2jserver/build/olympiad.properties /home/l2jserver/gameserver/configcp -rf /home/l2jserver/build/LoginServer_loop.sh /home/l2jserver/login/cp -rf /home/l2jserver/build/hexid.txt /home/l2jserver/gameserver/configcp -rf /home/l2jserver/build/chmod 750 /home/l2jserver/login/*.shchmod 750 /home/l2jserver/gameserver/*.sh # clean not important (for me) filesrm -rf /home/l2jserver/*.txtrm -rf /home/l2jserver/*_LIC*rm -rf /home/l2jserver/*.html # clean -_- windows files =Prm -rf /home/l2jserver/gameserver/*.batrm -rf /home/l2jserver/gameserver/*.exerm -rf /home/l2jserver/login/*.batrm -rf /home/l2jserver/login/*.exe # backup for mysql with dumpsmysqldump -u l2jserver -ppasswordhere --database yourdatabase > /home/l2jserver/opt/backup.sql #I have a empty script.sql.. to apply some sql scripts if is neccessary after updatemysql -u l2jserver -ppasswordhere --database yourdatabase < /home/l2jserver/opt/script.sql Code: Select all
crontab -eCode: Select all
0 0 * * 0 /home/l2jserver/opt/build.shCode: Select all
chmod 750 /home/l2jserver/opt/build.sh
The backup feature is only available on the paid versions of NaviCat but writing up a short scripts is an alternative to paying for the paid versions. In fact, the script I wrote took all but 5 minutes to write, then another 2 minutes to set up 2 backup per day using Scheduled Tasks.Deadmeat wrote:I used Navicat to do scheduled backups automatically every 12 hours, I know SQL dumbs are fasters to restore but it's a lot easyer to just click a checkbox on the talbes you want to restore and not have to take the time to make a script to do it for you, I used a Windows XP Pro computer that was on the same LAN as the servers so I don't know if this would be a good idea to use over the Internet if your servers are hosted by someone else and not yourself.