There is a change in the scenario after running the first trial.
My diff portion that i was trying to achieve is still there and is suppose to be for the user names.
the other portion is decried below.

Server A
1. has my "diff" bash script (diff is the name of my script)
2. we login using mysql user id "xyz" for the mysqldb from the script
3. no mysql db exist here
4. querydb file not generated here so when we look in /tmp we see the other two instead
5. "userlist" generated here
6. "final" file generated here

Server B
1. does not have bash script
2. has mysqldb
3. the file is not created here as well because the mysql user id "xyz" does not have permission on any files and folders on this server
4. userlist file is not generated here
5. final file is not generated here


the querydb file is to be created on Server A. nothing to be created on the database server

this portion:-

CMD="show databases; use metadata; show tables; select * from usernames; select * from personaldata; describe usernames; describe personaldata; select usernames.SNo, usernames.DataTelid, usernames.UName, personaldata.ActiveInactive from usernames, personaldata where usernames.DataTelid=personaldata.DataTelid into outfile '/tmp/querydb';"

the above portion is not creating the file on server B because the new user id we created in the m,yhsql database does not have any sort of permission to create anything in the files or folder of that server B. We want the above query on server A. What modification do i have to do. Where will i insert the ssh command.

The scenario is very confusing but that is the environment i have the restrictions. Nothing is to be created on the Server B and I cannot execute the script on Serve B. Help

no response?

@jschiwal please let me know what you think of my situation. am not sure why I am not getting any response

1. you need to enable a remote mysql cxn/login to B from A
http://www.cyberciti.biz/tips/how-do...se-server.html

2. its simpler if you put the sql cmds in a file and call it thus https://dev.mysql.com/doc/refman/5.0...-commands.html, inserting user, passwd, host on the cli as per (1.).

PS: this is a purely volunteer site; we answer which qns we want to, when we want to.
If you have serious time issues, you should find a company that offers paid support.

Can someone break this down for me. I am searching it further as well. diff filename 1 filename2 | grep '^[<>]' | sed "s/^> (.*)/\1 some string/;"