Current location - Health Preservation Learning Network - Slimming men and women - Sql data slimming
Sql data slimming
The files backed up by 1.SQL can be deleted regularly, which will not affect the use.

2. It is normal that the memory utilization rate is 1700M m.

3. Important note: SQL logs should be shortened regularly, otherwise the logs will become larger, resulting in too large backup files. Many times, the log file is too large, and the data itself is not large. After slimming, the files backed up every day are greatly reduced.

Method: Open the query analyzer.

Dump transaction "database name" with no_log

Backup log "database name" with no_log