Sign in to follow this  
Followers 0
Killerpoodezz

2nd server data base

3 posts in this topic

greetings to the DB Gods , 

I just started to work on our second server . 

I am using Mysql 

I created a new schema called exile 2 , when I load in the exile.sql it defaults back to exile (original) and nothing is loading to the new  .

am sure am missing something very simple if someone can point in the way .thanks

 

KP

Share this post


Link to post
Share on other sites

In the SQL you can change the name before running it. 

CREATE DATABASE IF NOT EXISTS `exile` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `exile`;


Change exile to whatever name you want. Once you have that completed you need to edit the second servers extdb-conf.ini to call on that database and not the default exile database the first server calls to. Open your @ExileServer folder and locate the extdb-conf.ini file.

Open the file and scroll to the bottom. Edit line 68 to say the new database name.

Type = MySQL
Name = exile_2
Username = Username
Password = Password
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

 

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
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.