[DiscordArchive] what do you typically use for SQLbackups? Just the export functilon in HeidiSQL or something else?
[DiscordArchive] what do you typically use for SQLbackups? Just the export functilon in HeidiSQL or something else?
Original source
That makes sense because there are no writing operations in the DB that can cause corruption at restoring the DB if you shutdown the servers. This will happen not often but the danger is there.
rektbyfaith
04-15-2025, 03:47 PM #11Archived author: St0ny • Posted: 2025-04-15T15:47:33.781000+00:00
Original source
That makes sense because there are no writing operations in the DB that can cause corruption at restoring the DB if you shutdown the servers. This will happen not often but the danger is there.
Original source
In the years I have used AC with hourly backups there has NEVER been any issues what so ever
rektbyfaith
04-15-2025, 03:48 PM #12Archived author: Revision • Posted: 2025-04-15T15:48:16.263000+00:00
Original source
In the years I have used AC with hourly backups there has NEVER been any issues what so ever
Original source
The server isn't writing to the database continuously
rektbyfaith
04-15-2025, 03:48 PM #13Archived author: Revision • Posted: 2025-04-15T15:48:49.131000+00:00
Original source
The server isn't writing to the database continuously
Original source
Funnily enough, I’m working on one atm
rektbyfaith
04-15-2025, 03:51 PM #14Archived author: Barais • Posted: 2025-04-15T15:51:05.384000+00:00
Original source
Funnily enough, I’m working on one atm
Original source
Nowhere near complete though
rektbyfaith
04-15-2025, 03:51 PM #15Archived author: Barais • Posted: 2025-04-15T15:51:11.075000+00:00
Original source
Nowhere near complete though
Original source
also they exist (privately)
rektbyfaith
04-15-2025, 03:51 PM #16Archived author: Rymercyble • Posted: 2025-04-15T15:51:56.389000+00:00
Original source
also they exist (privately)
Original source
I’ve only setup level 1 keystones, the dungeon teleport NPC and the aura. No scaling or affixes yet
rektbyfaith
04-15-2025, 03:52 PM #17Archived author: Barais • Posted: 2025-04-15T15:52:17.417000+00:00
Original source
I’ve only setup level 1 keystones, the dungeon teleport NPC and the aura. No scaling or affixes yet
Original source
Just because it's never happened to you doesn't mean there's no risk. As I said, the probability isn't very high, but if you want to be on the safe side, you should disable everything that can write to the database before backing it up.
rektbyfaith
04-15-2025, 03:53 PM #18Archived author: St0ny • Posted: 2025-04-15T15:53:51.577000+00:00
Original source
Just because it's never happened to you doesn't mean there's no risk. As I said, the probability isn't very high, but if you want to be on the safe side, you should disable everything that can write to the database before backing it up.
Original source
That's exactly why the probability is low.
rektbyfaith
04-15-2025, 03:54 PM #19Archived author: St0ny • Posted: 2025-04-15T15:54:08.684000+00:00
Original source
That's exactly why the probability is low.
Original source
If you want to waste time on shutting the server down every single time you want to back up the database, go ahead.
rektbyfaith
04-15-2025, 03:57 PM #20Archived author: Revision • Posted: 2025-04-15T15:57:12.507000+00:00
Original source
If you want to waste time on shutting the server down every single time you want to back up the database, go ahead.
1 Guest(s)
1 Guest(s)