Setup the Database - GiR-Zippo/Strawberry335 GitHub Wiki

Prerequisite

It is necessary to have a functional MariaDB/MySQL-Server and a new account for the core. This account can be locked to the databases which we are creating in the next steps.

Lost&Found

The SQL-Files can be found [here] (https://github.com/GiR-Zippo/Strawberry335/tree/master/sql/base) and we need all of them. ;)

Setting up the databases

I'll use the standard mysql-client, cuz it's better for big files.

Lets start:

$mysql -u root -p

This will connect you to your databaseserver, the output could look like this:

Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 926

Server version: 10.1.12-MariaDB-1~trusty mariadb.org binary distribution

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

That's it we are in and can proceed with the next steps.

Let's create some databases.

CREATE DATABASE AUTHDATABASE;

CREATE DATABASE CHARACTERDATABASE;

CREATE DATABASE LOGDATABASE;

CREATE DATABASE LOGONDATABASE;

And now fill these with some data.

USE AUTHDATABASE;

\. auth_database.sql

USE CHARACTERDATABASE;

\. characters_database.sql

USE LOGDATABASE;

\. log_database.sql

USE LOGONDATABASE;

\. logon_database.sql

TODO: Add the Worlddatabase.

That's it. Your databases are installed.