diff options
| author | Francesco Borzì <borzifrancesco@gmail.com> | 2019-08-02 18:01:56 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-08-02 18:01:56 +0200 |
| commit | e98676b92c1cfa28db00c8a649ec49c75bb7e57b (patch) | |
| tree | 9a59c5bd34750ad0234523757ac48b490e71a18a /docs/Database-Setup.md | |
| parent | 3031d8193408da1bb3421dbf02c15fcda432e6dd (diff) | |
| download | wiki-e98676b92c1cfa28db00c8a649ec49c75bb7e57b.tar.gz wiki-e98676b92c1cfa28db00c8a649ec49c75bb7e57b.tar.bz2 wiki-e98676b92c1cfa28db00c8a649ec49c75bb7e57b.zip | |
Update Database-Setup.md
Diffstat (limited to 'docs/Database-Setup.md')
| -rw-r--r-- | docs/Database-Setup.md | 29 |
1 files changed, 3 insertions, 26 deletions
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. |
