how make mysql query log before runing query

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 how make mysql query log before runing query Reviewed by ilham.sp on February 01, 2021 Rating: 5

No comments:

Notice

This site uses cookies from Google to deliver its services, to personalise ads and to analyse traffic. Information about your use of this site is shared with Google. By using this site, you agree to its use of cookies.Learn More

Powered by Blogger.