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

[MoparTech 0]

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

[Mezo 1264]

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 September 26, 2015 by Taylor Swift

[MoparTech 0]

Thanks TS, i knew it was so simple...arghh hours of learning.....

[<Z>SneakyDude 24]

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.

[Bruiser 12]

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 December 24, 2015 by Bruiser

[Diggz 16]

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://exile.majormittens.co.uk/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.

[Mrblack 1]

On 9/26/2015 at 3:27 PM, Mezo 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!

Hey, i did this and the server is still not loading to the database