TrinityCore / TrinityCore/TrinityCore

100% sql free core installation

Open
#19,066 26 comments 5 reactions 1 assignee View on GitHub

@Naios is already working on this.

Since Feb 7, 2017.

Branch-3.3.5a Branch-master Comp-Core Priority-FutureFeatureRequest Sub-Miscellaneous
Dominant language
C++
Stars
10.8k
Forks
6.4k
Avg merge
3d 16m
Merged PRs (30d)
6

Description

Description:

Feature Request: 100% SQL free installation

on run worldserver:

If databases are present, check they contain all needed tables.

If they don't contain all needed tables warn about database(s) is used by some other project and don't allow to use then to install tc.

If databases are missing or they don't have data, show the following messages:

  • "Databases missing, we need root user password or user with CREATE and GRANT permissions. Press enter for root user or write user name with CREATE and GRANT permissions."

  • "We will create 3 (4) databases named auth_335, characters_335, world_335. If you want to use different names, write them separated by "," don't use spaces on database names. Press enter for default names."

    "Database names already exists and they don't contain data, you want to use them?"

    "Database name already exists and it have data, but they don't contain trinitycore tables, are you sure this is the database(s) you want to use?"

    "Databases auth_335, characters_335, world_335 created"

  • "We will create one user to allow to use the databases, by default this user will be trinitycore. Press enter to accept or write desired username."
    "User name name already exist and it has access to the following databases: databases, are you sure this is the user you want to use?"
    "Username name created and assigned to the following databases: databases"

  • "We will give (user name) one random password, it will be shown after this row. Press enter to accept or write your desired password."

and after that, update conf files.

Current behaviour: (Tell us what happens.) You need to run create_mysql.sql, then start core.

Expected behaviour: (Tell us what should happen instead.) You start core.

Branch(es): 3.3.5 / master (Tell us which branch(es) this issue affects.)
ALL
TC rev. hash/commit: 0659a85

TDB version: ALL

Operating system: ALL

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.