Resource icon

xF1 Add-on Auto Database Backup Script 1.0

No permission to download
These are 2 scripts I wrote to automate the nightly backup of my databases and upload them to a remote location via FTP.

There is a bash script that you call from cron at a time of your choice. This uses mysqldump to make a copy of your database, compress is using pbzip2 (adjust to bzip2 or gzip if you don't have pbzip2 installed), and then calls the upload.pl script to upload the file via FTP to the remote site (keeping 5 rolling days worth of backups).

For my own use, I backup several databases each night, so the perl script is creating an array of file names, and using a foreach loop. If you only have a single database to back up, you can remove the foreach loop, and set the array to be a single variable.

Feel free to adjust to suite your own needs, and I'll try and provide assistance as and where needed.

xenforo_com_community_attachments_dbbackup_png_43676__.png
xenforo_com_community_attachments_upload_png_43677__.png
  • Like
Reactions: ReaZ, rytezee, Desert Cheetah and 10 others
Author
AnimeHaxor
Size
1.4 KB
Extension
zip
Downloads
11
Views
666
First release
Last update

More resources from AnimeHaxor

Similar resources

Auto Close Threads AnimeHaxor
Close threads after x amount of days has passed since either the first post or the last.
0.00 star(s) 0 ratings
Downloads
27
Updated
Auto Complete Location Admin
A simple jquery based addon for auto completing location
0.00 star(s) 0 ratings
Downloads
42
Updated
Auto Delete AnimeHaxor
Auto delete threads in selected forums.
0.00 star(s) 0 ratings
Downloads
17
Updated
Rebuild message auto link...
0.00 star(s) 0 ratings
Downloads
6
Updated
While a URL is being auto linked, the page title is fetched and added to the post.
0.00 star(s) 0 ratings
Downloads
15
Updated
AdBlock Detected

We get it, advertisements are annoying!

Sure, ad-blocking software does a great job at blocking ads, but it also blocks useful features of our website. For the best site experience please disable your AdBlocker.

I Disabled AdBlock