Your data is the lifeblood of your FiveM project, and losing that information because your forgot to make a manual backup can be devastating. However, with this System for automatic database backups, you no longer need to worry. The Systems creates a new file for each backup so you can recover data from minutes, hours, days or even weeks ago. You can also use an ingame command to create a Backup at any moment.
No need for external Programs which needs to be configured or manual backups anymore! Just drag and Drop installation!
Very easy installation
You just need to put the script in your ressource folder and ensure it in your server / ressource.cfg ! After that insert your Database name in the givin parameter in the config.lua and setup your custom time configuration as your desire. You can also Setup a Max amount of Backups that should be created to not fill your backup folder with tons of files. If the Max amount is reached, the oldest backup file will be automaticlly deleted.
Possible time Configurations can be:
Every Restart
every 10min
every 2 hours
every 2 days
How to insert the backup ?
The System creates a valid SQL File that you can import into your database to restore your data!
Config = {}
Config.BackupPrints = true
Config.Databasename = "YOUR_DATABASE_HERE" --importend for keys and constraints
----------- INFORMATIONS-----------
-- MIN AMOUNTS FOR TIME DIFFERENCES
-- MIN HOUR = 1
-- MIN MINUTE = 10
-- IF YOU USE "m"(minute) or "h"(hour) the script will make a backup after each script restart and after x amount of time you setup
-- If you want to backup only after each script restart you can set Config.TimeDifference = "d" and Config.SaveEveryUnit = 0
-- If you use Config.TimeDifference = "d" and a Config.SaveEveryUnit over 0 the script will backup on the next script restart the after time limit it reached
Config.TimeDifference = "d" -- "d":day, "h":hour, "m":minute
Config.SaveEveryUnit = 1 -- IF "h" MIN AMOUNT 1 , IF "m" MIN AMOUNT 10
Config.MaxBackups = 14
Config.ManualDataseBackupCommand = "dbbackup"
Config.AllowedBackupCommand = { -- INSERT STEAM IDS OF PEOPLE WHO ARE ALLOWED TO DO A DATABASE BACKUP MANUAL WITH COMMAND
'steam:1100001243g2348'
}
Because people dont want to Work and Setup a terminal with commands with they dont know how to Code at all. Also the Guide ist for Linux so people would have to lookup the right commands for there os system also.
Just to play devil’s advocate, this appears to be a ready-made solution for the matter, unlike the current ways which require a certain level of expertise, time and know-how to set up correctly. I’m by no means defending anyone here - in fact, I despise paid scripts altogether as much as the next guy - but I imagine this release will have its customers. The amount being asked for is within reason for people who dont want to bother doing it themselves and would rather spend a little instead to get it set it up with no hassle.
yeah if you have a server which never restarts you can do it, but most servers restart at least 2 times a day which will reset the timer because the script restarts and doesent save the last save date and time @marshular
I understand your point here with the script, however there are also a handful on GitHub that are based outside. This then runs independently of the FxServer. I don’t want to spread hate or anything else here, though. Go your way, keep improving, but maybe next time check/rethink if this A is already available everywhere for free and B if a built-in function (mysqldump) that you only call is really worth 10€.
Not to hate, but here’s a free option that doesn’t need much MySQL knowledge, just connect your DB, set the intervals and you’re done. If you want to do it properly, you can set up a FTP connection to store it elsewhere or on the cloud.
Yeah there are extern tools that you have to setup yourself or code it yourself. Clearly there are alternatives but thsi script just provides a single drag and drop ressource where you just have to edit 2 or 3 lines in the config. Also i dont really get 10eur out of this at all. You have to consider -19% tax and -x% plattform fee of tebex
yeah need also an installment of an extern programm and a setup etc. I never said my script is the only solution but it very easy to use and doesent need any extern programms or knowledge on how to connect your database etc. Also you can use the programm only for 2 databases for free otherwise it also cost money. So you cant use the program on more then 2 servers
To be honest, I have to say that it’s impressive how you defend your work/script. It seems that you are really convinced of your product. But I won’t discuss it any further, as it doesn’t have much more value.
