How to use command delete the user_log data

2019-12-21  FAQ  580 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

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

How to use command delete the user_log data Picture3

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 Picture4

How to use command delete the user_log data Picture5

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

How to use command delete the user_log data Picture6

FAQ DOWNLOAD

How to use command delete the user_log data Picture7How to use command delete the user_log data.docx

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!

Mariana(Spanish) Zach Fan Frank Liu Candy
Sunny