— redirect_from: “/Database-squash” —

<!DOCTYPE markdown> # Database Squash

## Introduction

We do this to update the base files so that a clean install of the server is done quicker and all update files are not needed to be run, as they will already exist in the base files.

## How to

{% include warning.html content=“These steps are only for project maintainers who intend to update base files.” %}

{% include important.html content=“No SQL changes should be merged during the Base Squash.” %}

We ONLY squash into BASE files. We never move files. ARCHIVE dir is UNUSED. All update files ALWAYS exist in the updates dir.

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.

How to do the squash.

{% include important.html content=“A squash needs to be done on a clean database. Drop all tables in Auth, Characters and World.” %}

1. Update the acore.json file. Increment version by one 2. Create a new file in the updates/db_world/ dir, the file should be incremented containing

{% include note.html content=“It should NOT be placed as a pending update and should only be done on world db. This is because we want the updated DB version to follow into the base files” %}

```sql UPDATE `version` SET `db_version`='ACDB 335.11-dev', `cache_id`=11 LIMIT 1; ``` {% include note.html content=“Remember to increment the db_version and cache_id the same as acore.json” %}

4. Drop all your databases, and run Worldserver to populate a clean database. 5. Export the databases using i.e HeidiSQL

{% include important.html content=“Set the following values </br» Tables → DROP + CREATE </br» Data → Delete + insert (truncate existing data) </br» Max INSERT size → 1024 </br>This is so that no unexpected issues occur.” %}

6. Move the exported table files into the base directory to update the existing files. 7. Make a PR

{% include important.html content=“See https://github.com/azerothcore/azerothcore-wotlk/pull/18197 as a reference how to squash into Base files.” %}