Can I truncate log tables?
Because my log tables became 6GB. And not working export, Backup log functions.
Go to admin > system > backup there is a button there that says Backup/Delete Lob Data. This will help you.
https://www.open-emr.org/wiki/index.php/Backing_Up_Using_the_Built_In_Tools
I tried that. But it’s getting error.
I think it’s because of log table is over 6GB.
What will happen if I just truncate it?
Nothing will happen. If you want to keep the data in the table. You can export the table first then truncate it. Truncating the table will have no impact on the program operation other than making it operate better.
If you do anything manually to the log table, also make sure you do the same to the other 2 log tables (since they all map to each other; the backup log function does this automatically):
log_comment_encrypt
api_log
1 Like