[DiscordArchive] Hi, I've setup mysql backups for our server. Is `acore-world` needed for backups?
[DiscordArchive] Hi, I've setup mysql backups for our server. Is `acore-world` needed for backups?
Original source
Hi, I've setup mysql backups for our server. Is `acore-world` needed for backups?
rektbyfaith
02-07-2023, 02:52 PM #1Archived author: Ethan • Posted: 2023-02-07T14:52:33.028000+00:00
Original source
Hi, I've setup mysql backups for our server. Is `acore-world` needed for backups?
Original source
yeah
rektbyfaith
02-07-2023, 02:54 PM #2Archived author: mynameismeat • Posted: 2023-02-07T14:54:27.425000+00:00
Original source
yeah
Original source
Only if you make custom changes, but at that point just store the custom changes in their own queries
rektbyfaith
02-07-2023, 02:54 PM #3Archived author: Bench • Posted: 2023-02-07T14:54:34.397000+00:00
Original source
Only if you make custom changes, but at that point just store the custom changes in their own queries
Original source
^ that probably makes more sense
rektbyfaith
02-07-2023, 02:54 PM #4Archived author: mynameismeat • Posted: 2023-02-07T14:54:51.345000+00:00
Original source
^ that probably makes more sense
Original source
No custom changes. So will it be fine if I only keep a backup of it once a week? Mainly making considerations since the backup is 200-300mb (not sure if it will grow but we just started)
rektbyfaith
02-07-2023, 02:56 PM #5Archived author: Ethan • Posted: 2023-02-07T14:56:16.562000+00:00
Original source
No custom changes. So will it be fine if I only keep a backup of it once a week? Mainly making considerations since the backup is 200-300mb (not sure if it will grow but we just started)
Original source
I take backups like this and it works fine for the most part
```bash
docker container run --rm -it \
-v /data/backup/azerothcore:/out \
mysql:8 bash -c "mysqldump -u USER -pPASS -h HOST --port PORT --all-databases > /out/databases.sql"
```
rektbyfaith
02-07-2023, 02:56 PM #6Archived author: mynameismeat • Posted: 2023-02-07T14:56:17.434000+00:00
Original source
I take backups like this and it works fine for the most part
```bash
docker container run --rm -it \
-v /data/backup/azerothcore:/out \
mysql:8 bash -c "mysqldump -u USER -pPASS -h HOST --port PORT --all-databases > /out/databases.sql"
```
Original source
I mean if you don't make any custom changes, you don't need to make backups of it at all. You can honestly wipe it every other week and it'd be just as well
rektbyfaith
02-07-2023, 02:56 PM #7Archived author: Bench • Posted: 2023-02-07T14:56:44.524000+00:00
Original source
I mean if you don't make any custom changes, you don't need to make backups of it at all. You can honestly wipe it every other week and it'd be just as well
Original source
Awesome. That solves the space issue then. Thank you guys again
rektbyfaith
02-07-2023, 02:57 PM #8Archived author: Ethan • Posted: 2023-02-07T14:57:17.222000+00:00
Original source
Awesome. That solves the space issue then. Thank you guys again
Original source
As far as custom changes go, you can just drop sql files in `data/sql/custom/...` to persist them
rektbyfaith
02-07-2023, 02:58 PM #9Archived author: mynameismeat • Posted: 2023-02-07T14:58:22.101000+00:00
Original source
As far as custom changes go, you can just drop sql files in `data/sql/custom/...` to persist them