nixCraft Linux Forum

nixCraft

Linux / UNIX Tech Support Forum

How to compare records in two tables in seperate My Sql database using perl script

This is a discussion on How to compare records in two tables in seperate My Sql database using perl script within the Coding in General forums, part of the Development/Scripting category; Hi, I have two different databases on two different servers one is local server and another is remote server. i ...


Go Back   nixCraft Linux Forum > Development/Scripting > Coding in General

Linux answers from nixCraft.


Coding in General Discussion on PHP/Perl/Python/Ruby/GNU C or C++. MySQL, PgSQL and (X)HTML or any other programming languages you want.

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 22-08-2008, 06:49 PM
Member
User
 
Join Date: Feb 2008
OS: fedora
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
chandanperl is on a distinguished road
Default How to compare records in two tables in seperate My Sql database using perl script

Hi,
I have two different databases on two different servers one is local server and another is remote server.
i have to fetch data i.e job status from remote server database table and compare that job status to local server database table.
And update job status fields to local server database table.

example:
remote server->database->table->jobstatus(say jobstatus Running R )


local server->database->table->jobstatus(say jobstatus completed C)

so i have to update R to C on local server.

Thanks
Reply With Quote
  #2 (permalink)  
Old 26-08-2008, 04:43 PM
nixcraft's Avatar
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
OS: RHEL
Scripting language: Bash and Python
Posts: 2,710
Thanks: 11
Thanked 245 Times in 184 Posts
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default

Is it MySQL or any other database server?
__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help
Reply With Quote
  #3 (permalink)  
Old 27-08-2008, 09:52 AM
amitabh's Avatar
Contributors
User
 
Join Date: Jul 2008
Location: New Delhi
OS: FreeBSD
Posts: 99
Thanks: 0
Thanked 4 Times in 3 Posts
Rep Power: 4
amitabh has a spectacular aura about amitabh has a spectacular aura about amitabh has a spectacular aura about
Send a message via MSN to amitabh Send a message via Yahoo to amitabh Send a message via Skype™ to amitabh
Default

From your topic header, I assume you have mysql server at both ends. Which language are u using?
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
Change root password using perl script? Raj1 Solaris/OpenSolaris 8 13-06-2008 11:01 PM
Simple ipcalc perl script unixfoo Shell scripting 0 24-01-2008 06:59 PM
Shell scripting: How to compare float values chanderbio Shell scripting 1 26-07-2007 05:46 PM
How to List my tables in Oracle database Databases servers 3 20-12-2006 03:25 PM
Sorting individual records in a file based on some fields cucu81 Shell scripting 1 25-07-2006 03:08 AM


All times are GMT +5.5. The time now is 11:34 PM.


Powered by vBulletin® Version 3.8.5 - Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2
©2005-2010 nixCraft. All rights reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38