summaryrefslogtreecommitdiff
path: root/docs/database-manual-setup.md
blob: dacc4812ec7f3b4f6c20a135983681ffd90e8554 (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
27
28
29
30
31
32
---
redirect_from: "/Database-Manual-Setup"
---

# Database Manual Setup

##  How to setup the AzerothCore DB manually

### MySQL client tool

In order to set up your database, you can use whatever MySQL client you like. Some examples [here](Database-client.md).

We will assume that you already know how to perform the basic tasks like creating a new database, selecting a database and importing a SQL dump file. If you don't, don't worry: it's very easy and you will find a lot of guides on Google, whatever MySQL client tool you're using.

### Creating the databases

Create three empty databases:

- `acore_world`
- `acore_characters`
- `acore_auth`


### Importing the SQL files

The SQL files are located under `/data/sql/` directory.

In `data/sql/base` there are the files to create the base structure & contents for the 3 database (world, auth and characters).

Similarly, in `data/sql/updates` there are the updates that our developers add with time.

Importing those files manually one by one is a long process that can be automated. The script `apps/db_assembler/db_assembler.sh` allows you to assemble those files (i.e. merge them together), so the process of importing them will be faster.