wow-classic-db-docker

A simple Docker Compose environment for spinning up a WoW Classic (Vanilla) MySQL database.

Requirements

• Docker
• Docker Compose plugin

Why Use This Project?

I mainly developed this project as I like to mess with the data WoW Classic databases - extracting information about items and NPCs and learning about the inner workings. It is not really suitable for a production server build, but some tweaks could be made to improve performance and make data persistent using volumes. Please note that this build only includes the "world" database, and the usual "realm", "characters" and "logs" databases are not included. Basically, this is just the data that contains in-game information, and not the database configuration required for hosting a full MaNGOS-style server.

Quickstart

• Change credentials in the .env file if you want
• Change Dockerfile option in docker-compose.yml to Dockerfile-cmangos or Dockerfile-vmangos
• Start containers using docker compose up --build

Selecting Database Source

There are a bunch of WoW Classic database options available. This projects supports Continued MaNGOS as it is reliable and robust, and Vanilla MaNGOS as it has built in support for Vannila patch progression.

In the docker-compose.yml file, set the Dockerfile to property to the desired source. The options are:

• CMaNGOS version uses Dockerfile-cmangos
• VMaNGOS version uses Dockerfile-vmangos

Simply comment out line 10 or 11 of the docker-compose.yml file to either Dockerfile. For example:

dockerfile: Dockerfile-vmangos

Start Containers

Use Docker Compose plugin to start the MySQL and Python containers:

docker compose up --build

Insert Database Contents

This process can be either manual or automated. By default, it is set to manual - mainly so the container can be restarted without performing too much repitition of tasks. To manually insert the data, just enter the Docker container and run the initialization script for the specific MaNGOS version being used.

docker exec -it wow-classic-db bash /opt/init_cmangos.sh
OR
docker exec -it wow-classic-db bash /opt/init_vmangos.sh

If you want the container to automatically insert the database when started, uncommnet out the following line in the Dockerfile-cmangos file. Do the same thing for the Dockerfile-vmangos file.

# Copy auto populate script to either:
# 1) /opt - then run it manually
# 2) docker entrypoint - which will auto run on container start
# Comment out one which one you don't want to use...
COPY ./init_cmangos.sh /opt/init_cmangos.sh
# COPY ./init_cmangos.sh /docker-entrypoint-initdb.d/init_cmangos.sh