summaryrefslogtreecommitdiff
path: root/data/sql/base/database-squash.md
blob: 626047e27698ae43971d7a02cf701bf7374ade7b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
New process around handling database squashes since https://github.com/azerothcore/azerothcore-wotlk/pull/18197

> [!CAUTION]
> These steps are only for project maintainers who intend to update base files.

## Requirements

1. MySQL
2. mysqldump

## Usage

> [!IMPORTANT]
> A squash needs to be done on a clean database. Drop all tables in Auth, Characters and World.

1. Run DatabaseSquash.sh (Located in ..\apps\DatabaseSquash\)
2. Make a PR

> [!IMPORTANT]
> No DB PRs should be merged during this process!

> [!NOTE]
> During the DB squash procedure, we do NOT move files.
> The archive dir is NO longer used as part of the DB squash procedure, 
> but simply as a place where to move update files when they get too many
> as the `updates` table in base files always will contain the entries from the updates dir they will never be run again on a clean setup.