Sample Header Ad - 728x90

How to get one complete column in mysql?

0 votes
1 answer
124 views
I have a script that will fetch Last_Error in mysql slave in a particular interval of time and write that to a file. To fetch Last_Error, currently I am using below command in the script. mysql -u root -pxxxxxxxxx -e "show slave status\G;" 2>&1 | grep -v "Warning: Using a password" |grep "Last_Error" The challenge I am facing is that grep "Last_Error" will only show that particular line and not complete error. For example, one of my Last_Error look like below:: Last_Error: Error 'TRIGGER command denied to user 'user'@'xx.xx.xx.xx' for table 'table_name'' on query. Default database: 'Db_name'. Query: 'UPDATE table SET user_status=0 WHERE contractid ='id.000.000'' and one another look like :: Last_Error: Error 'Duplicate entry '117583' for key 'PRIMARY'' on query. Default database: 'labs'. Query: 'insert into User (a,b,c,d) values ("Other","",now(),"") So basically I can't use A4 kind of switch with grep. Is it possible to get one complete column in mysql or any other work around?
Asked by Panda (101 rep)
Apr 21, 2017, 07:01 PM
Last activity: Apr 21, 2017, 07:56 PM