[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
what do you typically use for SQLbackups? Just the export functilon in HeidiSQL or something else?
rektbyfaith
04-15-2025, 03:13 PM #1Archived author: TDMCC • Posted: 2025-04-15T15:13:00.222000+00:00
Original source
what do you typically use for SQLbackups? Just the export functilon in HeidiSQL or something else?
Original source
mysqldump
rektbyfaith
04-15-2025, 03:13 PM #2Archived author: Mithria • Posted: 2025-04-15T15:13:32.632000+00:00
Original source
mysqldump
Original source
Ah, you said that my B
rektbyfaith
04-15-2025, 03:13 PM #3Archived author: TDMCC • Posted: 2025-04-15T15:13:51.613000+00:00
Original source
Ah, you said that my B
Original source
i've used heidi to export databases as well, restoring from that worked perfectly fine, i just prefer cli since i run linux and every .exe through wine is clunky
rektbyfaith
04-15-2025, 03:14 PM #4Archived author: Mithria • Posted: 2025-04-15T15:14:54.445000+00:00
Original source
i've used heidi to export databases as well, restoring from that worked perfectly fine, i just prefer cli since i run linux and every .exe through wine is clunky
Original source
my end goal is to automate my backups eventually, but i need to start small to make sure I don't break everything
rektbyfaith
04-15-2025, 03:15 PM #5Archived author: TDMCC • Posted: 2025-04-15T15:15:49.167000+00:00
Original source
my end goal is to automate my backups eventually, but i need to start small to make sure I don't break everything
Original source
and I need to ensure my backups actually work
rektbyfaith
04-15-2025, 03:16 PM #6Archived author: TDMCC • Posted: 2025-04-15T15:16:06.381000+00:00
Original source
and I need to ensure my backups actually work
Original source
Interesting. I currently just backup the whole VM. But doing a regular database export might also be good to do
rektbyfaith
04-15-2025, 03:26 PM #7Archived author: Slaxe • Posted: 2025-04-15T15:26:32.228000+00:00
Original source
Interesting. I currently just backup the whole VM. But doing a regular database export might also be good to do
Original source
I was thinking of backing up the whole VM but that's not super scalable over time. My end goal (with this being a private instance for just my friends and I to play on) is to have at LEAST a weekly backup that will run automatically during the work hours on Tuesday. Stops the authserver and worldserver properly, backs up the DBs, copies them to separate file share then upon completion of those tasks the authserver & world server are brought back online
rektbyfaith
04-15-2025, 03:28 PM #8Archived author: TDMCC • Posted: 2025-04-15T15:28:23.921000+00:00
Original source
I was thinking of backing up the whole VM but that's not super scalable over time. My end goal (with this being a private instance for just my friends and I to play on) is to have at LEAST a weekly backup that will run automatically during the work hours on Tuesday. Stops the authserver and worldserver properly, backs up the DBs, copies them to separate file share then upon completion of those tasks the authserver & world server are brought back online
Original source
Cause in theory as long as the configs are backed up, I can always recompile the actual build since I have the source codes for that backed up as well
rektbyfaith
04-15-2025, 03:28 PM #9Archived author: TDMCC • Posted: 2025-04-15T15:28:49.513000+00:00
Original source
Cause in theory as long as the configs are backed up, I can always recompile the actual build since I have the source codes for that backed up as well
Original source
Why shut the servers down when backing up the database? That makes no sense.
rektbyfaith
04-15-2025, 03:42 PM #10Archived author: Revision • Posted: 2025-04-15T15:42:59.387000+00:00
Original source
Why shut the servers down when backing up the database? That makes no sense.
1 Guest(s)
1 Guest(s)