From f309cf79bbb032a0686b7d04feb8fec18e600a84 Mon Sep 17 00:00:00 2001 From: Kitzunu <24550914+Kitzunu@users.noreply.github.com> Date: Sat, 12 Jun 2021 14:50:58 +0200 Subject: chore: file naming standard (#517) * A * file naming standard Fixes #491 * Revert "A" This reverts commit 1c225fed753554098069597a2bbcbe08213b76a1. * rename * Revert "rename" This reverts commit 65fd916faf8530ce258cc2b475c93971468680fe. * Revert "file naming standard" This reverts commit 6ca5a703a9e9d59f9c773029e4c04bfd012b6abb. * bye * Hi * Create the-staging-branch.md * 1 * Delete how-to-create-a-PR.md * Create how-to-create-a-pr.md * werafgt * Update the-modular-structure.md * wef --- docs/database-manual-setup.md | 32 ++++++++++++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 docs/database-manual-setup.md (limited to 'docs/database-manual-setup.md') diff --git a/docs/database-manual-setup.md b/docs/database-manual-setup.md new file mode 100644 index 0000000..dacc481 --- /dev/null +++ b/docs/database-manual-setup.md @@ -0,0 +1,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. -- cgit