[DiscordArchive] Im wondering, just finished an amazing db backup script that actually running every night a 4am. It
[DiscordArchive] Im wondering, just finished an amazing db backup script that actually running every night a 4am. It
Original source
Im wondering, just finished an amazing db backup script that actually running every night a 4am. It backed up my dbs. Id like to run t every hour but im wondering if its necessary to back up at each time the world db it kind of heavy for every hour backup ? what do you think ?
rektbyfaith
03-26-2024, 12:44 PM #1Archived author: Toosoon • Posted: 2024-03-26T12:44:29.417000+00:00
Original source
Im wondering, just finished an amazing db backup script that actually running every night a 4am. It backed up my dbs. Id like to run t every hour but im wondering if its necessary to back up at each time the world db it kind of heavy for every hour backup ? what do you think ?
Original source
do they really need to be backed up always at the same time to restored perfectly ?
rektbyfaith
03-26-2024, 12:45 PM #2Archived author: Toosoon • Posted: 2024-03-26T12:45:40.411000+00:00
Original source
do they really need to be backed up always at the same time to restored perfectly ?
Original source
Don't backup the world database. Store all your custom content in a .sql file and just don't do that one.
rektbyfaith
03-26-2024, 12:45 PM #3Archived author: Revision • Posted: 2024-03-26T12:45:45.972000+00:00
Original source
Don't backup the world database. Store all your custom content in a .sql file and just don't do that one.
Original source
I run backups every hour but never any world databases
rektbyfaith
03-26-2024, 12:45 PM #4Archived author: Revision • Posted: 2024-03-26T12:45:53.570000+00:00
Original source
I run backups every hour but never any world databases
Original source
Perfect ! That was my concern it thin about it and realised that why do i need to keep the world db each time, what about one save a day or every 12 hour ? Could it be enough ? By the way if you know, i tried to understand what data can be save beside donjuns reinit that are potentyly kept in world that can be usefull store frequently ?
rektbyfaith
03-26-2024, 12:48 PM #5Archived author: Toosoon • Posted: 2024-03-26T12:48:04.898000+00:00
Original source
Perfect ! That was my concern it thin about it and realised that why do i need to keep the world db each time, what about one save a day or every 12 hour ? Could it be enough ? By the way if you know, i tried to understand what data can be save beside donjuns reinit that are potentyly kept in world that can be usefull store frequently ?
Original source
Well, anything important shouldn't be saved in the world database, any changes to the world database should be stored in a .sql file. Importing it is what the worldserver does in case you need to reset it or lose the data. It's honestly a complete waste of data. Sure, if you really want to save data from the world database, one example that comes to mind is the disables table for the ah bot, you could just export that one manually whenever you make changes.
rektbyfaith
03-26-2024, 12:49 PM #6Archived author: Revision • Posted: 2024-03-26T12:49:52.561000+00:00
Original source
Well, anything important shouldn't be saved in the world database, any changes to the world database should be stored in a .sql file. Importing it is what the worldserver does in case you need to reset it or lose the data. It's honestly a complete waste of data. Sure, if you really want to save data from the world database, one example that comes to mind is the disables table for the ah bot, you could just export that one manually whenever you make changes.
Original source
Hence why I can store a months worth of hourly backups - 720 to be exact.
rektbyfaith
03-26-2024, 12:50 PM #7Archived author: Revision • Posted: 2024-03-26T12:50:21.472000+00:00
Original source
Hence why I can store a months worth of hourly backups - 720 to be exact.
Original source
Amazing you enlignht me ! Thanks this is mostly what i tough ! Thanks for your time
rektbyfaith
03-26-2024, 12:51 PM #8Archived author: Toosoon • Posted: 2024-03-26T12:51:08.516000+00:00
Original source
Amazing you enlignht me ! Thanks this is mostly what i tough ! Thanks for your time
Original source
You can run backups on the world database if you absolutely need to, just less frequent. It's just not something anyone here would encourage. I could also recommend storing it somewhere safe and not just locally on the server itself. I personally upload to MEGA whenever I run a backup so there's no way I would lose it.
rektbyfaith
03-26-2024, 12:55 PM #9Archived author: Revision • Posted: 2024-03-26T12:55:40.398000+00:00
Original source
You can run backups on the world database if you absolutely need to, just less frequent. It's just not something anyone here would encourage. I could also recommend storing it somewhere safe and not just locally on the server itself. I personally upload to MEGA whenever I run a backup so there's no way I would lose it.
Original source
Of course, for my side its backed up in a ceph pool, true nas and sent over night to a enterprise one drive. I guess i cant do more thant that XD
rektbyfaith
03-26-2024, 12:58 PM #10Archived author: Toosoon • Posted: 2024-03-26T12:58:03.314000+00:00
Original source
Of course, for my side its backed up in a ceph pool, true nas and sent over night to a enterprise one drive. I guess i cant do more thant that XD
1 Guest(s)
1 Guest(s)