Linux Database backups during globalsave

[Diazapam]

I've come with the idea to make a database backup during the globalsave (daily).
Just like RL tibia (probably) handles it.

Anyone got me tips on how to do it?

Using the globalsave option in TFS it should shutdown on its own but than...
First of all Linux has to copy the whole database to a file or another database (Which can be written to file later that day cause it isn't in use).
After that it should resume the screen that was already opened and execute ./theforgottenserver to start the server again.

And it shouldn't be on the root since I don't like using root running screens.

 

[dianagirl]

thanks!

HEhe bump!
Thanks it will be usefull!

 

[Diazapam]

Nobody who uses backups? xD

 

[stian]

Hmm, if the forgottenserver process shuts down then use this:

while true; do (./theforgottenserver; mysqldump -u username -pPassword database > mysql-backup-$(date +"%d-%m-%Y").sql); done

(Auto restarter, will take backup each time theforgottenserver shutsdown.