LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices

Reply
 
Search this Thread
Old 10-11-2012, 12:29 AM   #1
tarun28jain
LQ Newbie
 
Registered: Nov 2009
Posts: 3

Rep: Reputation: 0
Need to compare 2 tables data from different linux servers with mysql using perl script


I am having 2 Mysql servers installed on 2 servers.
They have same table in same database with some different records.
I need to compare data of these tables and generate logs.
Similar to MYSQL_DIFF generates logs comparing schemas, i need comparing logs of table data. i am not able to find any appropriate solution to this. Apart from writing the complete logic for doing this, is there any solution to do this using MYSQL_DIFF type of libraries.

Last edited by tarun28jain; 10-11-2012 at 05:43 AM.
 
Old 10-11-2012, 12:53 AM   #2
zhjim
Senior Member
 
Registered: Oct 2004
Distribution: Debian Squeeze x86_64
Posts: 1,446
Blog Entries: 11

Rep: Reputation: 182Reputation: 182
http://stackoverflow.com/questions/2...ysql-diff-tool.
 
Old 10-11-2012, 04:58 AM   #3
tarun28jain
LQ Newbie
 
Registered: Nov 2009
Posts: 3

Original Poster
Rep: Reputation: 0
I need a perl script written for it on RHEL command line platform. Also i need data to be comparedin those 2 tables. The link provided shows ways to compare data and schema using some softwares available as far as i understood. In case I misunderstood, could you please explain a bit.

Thanks for reply anyways
 
Old 10-16-2012, 06:54 AM   #4
zhjim
Senior Member
 
Registered: Oct 2004
Distribution: Debian Squeeze x86_64
Posts: 1,446
Blog Entries: 11

Rep: Reputation: 182Reputation: 182
I don't know in which languages the program are written. At least the programs included with maatkit which now can be found here http://www.percona.com/software/percona-toolkit run from command line. As far as I remeber they are either bash or perl scripts.

Does it really have to be perl? Or does it just need to be something that can be run from cmd?
I normaly just take a look at the available tools and then choose the best one on mostly "can it doe the job" and "do i understand the language (so i can tweak it myself)".
 
  


Reply

Tags
compare, mysql, perl


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Perl: Want to compare CGI input with data from a MySQL table resetreset Programming 1 11-20-2008 06:58 AM
How to compare records in two tables in seperate My Sql database using perl script chandanperl Programming 1 08-22-2008 09:33 AM
MySQL - Query and compare 2 tables rookiepaul Programming 4 05-12-2008 09:05 AM
Mysql Compare two tables from different databases baddah Programming 4 04-20-2006 12:36 AM
How to compare records in two tables in seperate My Sql database using shell script sumitarun Programming 5 04-14-2005 09:45 AM


All times are GMT -5. The time now is 09:00 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration