MySQL Setup

1. Linux Database configuration on Debian Linux (Jessie|Current Stable)

Requirements

   * mysql-server-5.5

Install requirements from apt-get

   $ apt-get install mysql-server-5.5

Set MySQL Configuration options: $ nano /etc/mysql/my.cnf

1. Inside the [mysqld] section set settings per below

• max_allowed_packet = 1000M
• key_buffer = 256M

1. Inside [mysqldump]

• max_allowed_packet = 1000M

$ systemctl restart mysql Setup:

   $ git clone https://github.com/evemuproject/evemu_server.git evemu
   $ cd evemu
   $ cd sql
   $ wget http://eve.alasiya.net/files/cruc/cru16-mysql5-v1.sql.bz2 -O - | bunzip2 > cru16-mysql5-v1.sql
   $ cd utils
   $ bash merge-ofic-updates.sh
   

Set MySQL Permissions:

   $ mysql -u root -p
     > CREATE USER 'evemu'@'%' IDENTIFIED BY 'evemu';
     > GRANT USAGE ON *.* TO 'evemu'@'%' IDENTIFIED BY 'evemu' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
     > CREATE DATABASE IF NOT EXISTS `evemu`;
     > GRANT ALL PRIVILEGES ON `evemu`.* TO 'evemu'@'%'; 
     > EXIT;
     

Change to the sql/ directory and execute:

   $ mysql -u evemu -p
     > use evemu;
     > source cru16-mysql5-v1.sql;
     > source ofic-updates.sql;
     > source evemu_static-dump.sql;
     > source evemu_dynamic-dump.sql;
     > source prime_db.sql;
     > source liveupdates.sql;
     > exit;
    ** TODO: Validate the PI tables before adding to official documentation.

Check that the AUTO_INC value in the entity table is set to 140000000

   $ mysql -u evemu -p
     > use evemu;
     > SHOW CREATE TABLE entity;
     > exit;

Add your account into the DB

   $ mysql -u evemu -p
     > INSERT INTO account (accountID, accountName, role, password, online, banned) VALUES(NULL, 'your_account_name', 5003499186008621056, 'your_password', 0, 0);
     > exit;