Emudevs - MMORPG Development

PrivateDonut · 2023-01-11T23:08:40+00:00

Today I will show you how to automatically backup your database daily. This is perfect in case you ever need to roll-back your database to a previous state. Step 1: Creating Backup Directories Now we will create the backup folders where we will store our database backups. cd /var mkdir backups cd backups mkdir auth | mkdir characters | mkdir world This will navigate you to the var directory and create the following folders â€˜backupsâ€™, â€˜backups->authâ€™, â€˜backups->charactersâ€™, â€˜backups->worldâ€™. Step 2: Creating Backup Script Letâ€™s create a script to backup the auth, character, and world databases and save it with the current year, month, and day appended to the file name. Letâ€™s create a new shell script inside the new backup folder. cd /var/backups nano backup.sh Now weâ€™ll type the information below into our new script: mysqldump auth | gzip > /var/backups/auth/auth.$(date +â€+%Y-%m-%dâ€).sql.gz mysqldump characters | gzip > /var/backups/characters/characters.$(date +â€+%Y-%m-%dâ€).sql.gz mysqldump world | gzip > /var/backups/world/world.$(date +â€+%Y-%m-%dâ€).sql.gz We will now need to give the shell script executable permissions by typing: chmod +x backup.sh Step 3: Setting Up Cron Job We will now be setting up a corn job to run daily at 0100 in the morning. Letâ€™s start by opening up crontab crontab -e Then we will need to add this line at the very bottom of the crontab. 0 1 * * * sh /var/backups/backup.sh Now you should have your automatic database backup setup to run every day at 0100. If you encounter any problems, please let me know.

Immerse yourself in a world of limitless possibilities and open the gateway to mmo emulation.

Emudevs
World of Warcraft
Guides

[Linux]How To Setup Automatic Database Backups For Your WoW Server

Thread starterPrivateDonut
Start dateJan 12, 2023
Tagged users None

PrivateDonut

Content Creator

Divine

LEVEL 29

191 XP

Jan 12, 2023
0
258

Thread Author
#1

Show hidden low quality content

You must log in or register to reply here.

Facebook Twitter Reddit Pinterest Tumblr WhatsApp Email Link

Emudevs
World of Warcraft
Guides

2,667

1,128

9,057

Kenetoday

This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept Learn more…

Top