From e98676b92c1cfa28db00c8a649ec49c75bb7e57b Mon Sep 17 00:00:00 2001 From: Francesco Borzì Date: Fri, 2 Aug 2019 18:01:56 +0200 Subject: Update Database-Setup.md --- docs/Database-Setup.md | 29 +++-------------------------- 1 file changed, 3 insertions(+), 26 deletions(-) (limited to 'docs') diff --git a/docs/Database-Setup.md b/docs/Database-Setup.md index f028c01..5685ef7 100644 --- a/docs/Database-Setup.md +++ b/docs/Database-Setup.md @@ -1,6 +1,6 @@ You can setup the database manually or using the automated script. -## Setup the DB using the automated script (recommended) +## How to setup the AzerothCore DB using the automated script ### Edit script configuration @@ -17,29 +17,6 @@ You can setup the database manually or using the automated script. - Select `import-all: Assemble & Import all` - Once the process is finished, you can exit the script. -## Setup the DB using the automated script manually +----------- -### MySQL client tool - -In order to set up your database, you can use whatever MySQL client you like. Some examples are [HeidiSQL](http://www.heidisql.com/download.php), [SequelPro](http://www.sequelpro.com/) and [phpMyAdmin](https://www.phpmyadmin.net/). - -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. +Alternatively, you could also [set up your DB manually](Database-Manual-Setup.md) but this process is harder and not recommended for beginners. -- cgit