[HELP] Merging MySQL Files? [HELP]

[idfk]

I don't really know how to explain but here it goes.

OK i'm trying to merge to MySQL together but they both have duplicate key entries. No i want to add the columns and data but no duplicate errors. Something like add them to the bottom of the columns?

 

[RastaLulz]

What exactly are you trying to merge?

 

[idfk]

What exactly are you trying to merge?

Just the normal Uber / phoenix MySQL's But i don't want one of the other data lost.

 

[Jian]

Just import both SQL files. It will work.

 

[idfk]

Just import both SQL files. It will work.

as i said i don't want duplicate entries :S

 

[RastaLulz]

as i said i don't want duplicate entries :S

You do realize that Uber and Phoneix have different database structures, right?

 

[idfk]

You do realize that Uber and Phoneix have different database structures, right?

yh i do, just checked its a uber sql

 

[RastaLulz]

yh i do, just checked its a uber sql

You can't merge two databases with different structures (unless you did some fancy PHP work).

 

[idfk]

You can't merge two databases with different structures (unless you did some fancy PHP work).

They both the same sql. -.-
Just corrected that, because i was looking @ the wrong sql

 

[Markshall]

They both the same sql. -.-
Just corrected that, because i was looking @ the wrong sql

Uber and Phoenix are set up differently, you can't just simply merge them together and expect everything to work all fine and dandy, as Rasta said, you'd have to do some nifty PHP shiz to make it work.

 

[Sean]

I managed to merge a phoenix db with an uberdb to get
uberCMS working with phoenix emu

I could give you that that then you can import your user tables over to it etc

 

[idfk]

I managed to merge a phoenix db with an uberdb to get
uberCMS working with phoenix emu

I could give you that that then you can import your user tables over to it etc

basically i want 2 sqls with different users. Since i am merging 2 of my retros.

 

[Jian]

basically i want 2 sqls with different users. Since i am merging 2 of my retros.

Why would you have 2 retros?

 

[Sean]

That would be to complicated since each user has a unique ID and merging would just mess them up. Just tell the retro with the least amount of users to re-register lol