CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI:
Merge databases

 



hlgladiator
Novice

Apr 14, 2008, 10:53 AM

Post #1 of 1 (2913 views)
Merge databases Can't Post

Hi there. I'm writing a plugin for game server bots which are coded in Perl. I need to merge 6 databases containing player names and their IP's into 1 master file. I'm hoping to be able to do so rather efficiently (in terms of resource usage), as it's going to be done at least a few times a day on a server that's relatively stressed at most times.

So, I'm merging 6 databases from SQLite into 1 large one, repeatedly (ipdb1.bat, ipdb2.bat, ..., ipdb6.bat ---> ipdbmaster.bat). I don't want duplicates, but if there is one player nick with multiple IP's, I need those to transfer, like so:

ipdb1.bat contains:

hlgladiator 12.23.34.45

ipdb2.bat contains

hlgladiator 12.23.34.46

ipdb3.bat contains 12.23.34.47

Would result in ipdbmaster.bat containing:

hlgladiator 12.23.34.45 12.23.34.46 12.23.34.47

Having it merged cleanly (like above) is more of a nicety than a necessity. If somebody could point me in the right direction, I would really appreciate it.

Thanks in advance,

-Glad

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives