Mysql cleaning of logs

Asked

Viewed 128 times

1

On my Mysql server the myaccess.log file located in Mysql/logs/ is of a large size, around 30GB. I would like if possible to reset this file, but I need to make sure it doesn’t compromise database information. If anyone can help me with procedures, I’d appreciate.

Thank you.

  • Before anything create a Backup of your database (if you haven’t done it yet) to prevent any attempt to end the data

  • In google I did not find any link of that name "myaccess.log" with mysql. Then it is necessary to look at the configuration what this file does before making any decision. Of course, do not forget to backup ALL.

  • I found about binary log in Mysql, but I have not yet identified whether it compromises the BD or not..

1 answer

-1

I use a program for editing files with very large sizes, just like yours. It’s called Pilotedit, exise paid and free version, which will suit you.

Follow the comments instructions, make a backup, change the file, and go up.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.