How to use command delete the user_log data

2019-12-21 FAQ 36 views shaofu

When we upgrade IVMS Server, if the user_log table have so many data, it will will slow, so we need to clear the user log first.


1. Use Navicat for MySQL software connect to mysql, then find the user_log table, you can download the software from this link.

https://www.dropbox.com/sh/a44t2tv3o78jok4/AAA6vG9AeX1yeDamAwcfMiSka?dl=0


How to use command delete the user_log data Picture1


How to use command delete the user_log data Picture2

How to use command delete the user_log data Picture3

2. Check the table information to know how many data does it have.


How to use command delete the user_log data Picture4


3. If the data is very huge, you can use command delete it, it maybe need some time to delete the data, when it finished, it will show like .

Command: truncate table user_log


How to use command delete the user_log data Picture5


How to use command delete the user_log data Picture6


4. Open the user_log table again, you will see it had cleared.


How to use command delete the user_log data Picture7

Still Have Questions?

If you would like help finding the right information to meet your requirement please leave us a message below, one of our sales representatives will be happy to assist you shortly!

Micheal Mariana(Spanish) Zach Fan Vivien Kong Mia Liu Amily