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