MoparTech

How does one create a second database/MYSQL connection so the tables process with the sql file?

6 posts in this topic

Im using MYSQL and Navicat, I cannot get a second database working for a new map i want to run on dedicated test server from same client PC. the execute exile. sql file wont inject the data into the tables of a new database.

what is the procedure in creating a second database with exile mission? Do i create a new connection or just add a new database to my working exile data base connection?  Do i need a different port to use another database , besides 3306?

I' ve been trying to run Esseker exile dedicated server, having a hell of time, getting "receiving server" hang, but server runs,game started.

thanks

Share this post


Link to post
Share on other sites

Find

/exileserver/mysql/exile.sqf

then change

CREATE DATABASE IF NOT EXISTS `exile` /*!40100 DEFAULT CHARACTER SET utf8 */; <<--- Change 'exile' to whatever you want the name of your database to be.

next line; change

USE `exile`; <--- Change this to the same name as above

____________________________

@ExileServer/Addons/extdb-conf.ini

Change

[exile]
Type = MySQL
Name = exile
Username = **********
Password = *********
IP = 127.0.0.1
Port = 3306
minSessions = 2
;maxSessions = 4
idleTime = 60
compress = false
; Should only use this if MySQL server is external. Also only for MySQL
Secure Auth = true
; Recommend you turn this on

Change 

'exile'

to the same as you did in the other files.

 

Once done, open your preferred Database tool and execute the SQL file.

Done!

Edited by Taylor Swift

Share this post


Link to post
Share on other sites
Advertisement

There will be a installation guide soon on this. I have many servers running, Its very simple.

Please review the installation guide on installing a server sometime in the future. To rehash, something that is being developed by @S would be not fair

since a video, and written guide is being done up.

1 person likes this

Share this post


Link to post
Share on other sites
On 9/26/2015 at 10:27 AM, Taylor Swift said:

Find


/exileserver/mysql/exile.sqf

then change


CREATE DATABASE IF NOT EXISTS `exile` /*!40100 DEFAULT CHARACTER SET utf8 */; <<--- Change 'exile' to whatever you want the name of your database to be.

next line; change


USE `exile`; <--- Change this to the same name as above

____________________________

@ExileServer/Addons/extdb-conf.ini

Change


[exile]
Type = MySQL
Name = exile
Username = **********
Password = *********
IP = 127.0.0.1
Port = 3306
minSessions = 2
;maxSessions = 4
idleTime = 60
compress = false
; Should only use this if MySQL server is external. Also only for MySQL
Secure Auth = true
; Recommend you turn this on

Change 


'exile'

to the same as you did in the other files.

 

Once done, open your preferred Database tool and execute the SQL file.

Done!

did you have to add to your page file in server O/S?

Edited by Bruiser

Share this post


Link to post
Share on other sites

i did it a different way, i believe this way doesnt work in 0.9.4 anymore, im not familiar with navicat, however if your using  workbench, i recommend following @happydayz instructions on this thread http://www.exilemod.com/topic/1143-create-2nd-database-on-dedi-box/ 

only thing i believe he missed out is once its created go to your extdb-conf.ini file in @exileserver and change 

Spoiler

[exile]
Type = MySQL
Name = change this to whatever filename you gave in happys instructions <---------------------------------------------------
Username = changeme
Password = changeme
IP = 127.0.0.1
Port = 3306
minSessions = 2
idleTime = 60
; Really should only use this if MySQL server is external. Also only for MySQL
compress = false
; Recommend you turn this on http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_secure-auth
Secure Auth = true

otherwise it will continue using your first database..

this worked for me and i now have 3 servers running on 3 different records, so let me know how you get on.

1 person likes this

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.