login to mysql with
mysql -u user -p
and entter password
next write this command
mysql> tee /lokasian_you_want_save_it/name_of_log
example :
mysql> tee /var/query/log_transfer/_querymaret_02-17_032020.sql
in my case i just running some query and all of my query and result will loged to file where we define with tee command.
how make mysql query log before runing query
Reviewed by ilham.sp
on
February 01, 2021
Rating:
No comments: