parasbshah

hey guys, i have a particular problem. I'm trying to merge two databases, they have the same function and dissimilar field names, duplicates, etc, etc. So, basically, I was wanting to use PremiumSoft Navicat to do the merge. However, it gives me errors when I try to connect, says that the username / password are not valid.

However, they ARE valid, and the problem isnt a configuration one. I'm guessing that ssh access is used via navicat, and it wont let me do that.

So that questions are such. !) has anyone figured out a way to get navicat to work here?

and 2) does anyone know any other way to merge databases? I know php and mysql fairly well (its what im writing this site in), but the problem remains that I do NOT know how to access and distinguish two databases on the same server.

Tips, comments, suggestions?

__________________
www.promorphus.com

Kickersny.com

Just use two instances of mysql_connect() ($conn1 and $conn2) and then use a separate mysql_select_db() for each $conn1 and $conn2. Then you could load each table into an array and array_merge() the two (or write your own function to skip whichever ones you want to skip).

Just a thought.

__________________
- Evan Charlton | [site] | Server - SH58

parasbshah

Ah, thanks, that will work....

thanks for the help!

__________________
www.promorphus.com