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
Last activity: Apr 21, 2017, 07:56 PM