Could you have 2 separate TTX installations but access the same data?

[Amateurfool]

We have 2 companies that access the same TTX system (one is a subsidiary of the other), however having slightly different configurations would have it's advantages (different web address, system email address, ticket submission form).

Is it therefore possible, to have 2 separate TTX installs, but both use the same "data" (i'm using MySQL).

I could experiment, but have too many things to do as it is. 

[Alex]

Yes, but make sure both config files specify the same database (host/port/dbid) and both config files point to the same ticket counter file, that is value of

ticketid

variable is the same. Using different operator databases (userdb variable) is not recommended as well.

[Amateurfool]

Cool, it's the "front end" part that I could do with changing, but i need the "data" side of things to be the same. I'll do some experimenting and see what results.

[geoffbrown]

Did you experiment and did it work OK?

I need to have TTX accessible in different languages but using the same data. This just might be a way to proceed.

[webcarvallo]

Hi folks. 
I think my problem is related to this.
From 3 years ago, I developed 4 ttx instalations for my employer, for 4 different business branchs.
All 4 are ttx v.2.24 and over MySQL databases, same structure.
2 of them residing in one web server (external) and the 2 at other server (external).

Recently my company ask me to put and get more info from ttx, so I developed and "extension" that get´s /put some extra data directly to 1 of the data base (php pages) , complementing ttx functionality and without altering ttx itself.  All works well.

BUT... very happy, now my employer ask me to merge all that 4 business branches ( 4 ttx systems) in only one central system in order to get all the data unified for the 4 branches and get the same extra functionality in order to get "total bussiness" data view not only each of 4 branches as separate.

I think it´s posible, maybe exporting the 4 (8, it´s 2 for each system) databases, merge all and then import, or maybe directly merge by some MySQLAdmin tool.  But my afraids are:
a) Tickets ID are the same (from 1 to xx) on each database, so it´s no so simple to add data lines from one to other.  Firts I need to change ID in order to don´t get repeated ones.
b) If I can set automatically or manually a prefix or sufix to ticket ID to identify data from one database from another,  I don´t know how mix the 4 database in 1.  MySQLAdmin seem not has such tool.
c) Same problem to mix the 4 "messages" database.

Any Ideas please?
I think one alternative is to add a new field to each database to identifiy the original database ("1" to "4") and then I can manage some way to get the correct ticket when ttx gets data for some query. I can fix it in my PHP extra application, but not sure to get it at ttx system.

I'll be very pleased to hear you... My sense is that the better way is to renumerate all tickets ID and then merge databases, but the problem is "how".  These at "ticket" database and at "messages" database as well.


Pos Data:

Maybe better is to add as new tables the content of the other databases in one (the bigger one):
Situation Now:
Database 1 has 2 tables "tickets" and "messages".
Database 2 has 2 tables "tickets" and "messages".
Database 3 has 2 tables "tickets" and "messages".
Database 4 has 2 tables "tickets" and "messages".

Possible new situation:
Database 1 has 8 tables: "tickets1" "tickets2"..."tickets4" and "messages1" to "messages4"
It maybe a good aproach.(¿?)



Thanks in advance for your help/suggestions.
Andrés.