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 $ 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;
 * 1) Inside the [mysqld] section set settings per below
 * max_allowed_packet = 1000M
 * key_buffer = 256M
 * 1) Inside [mysqldump]
 * max_allowed_packet = 1000M