Page 1 of 1

Clean up tables

Posted: Tue Jan 01, 2013 7:55 am
by clinterman
I looked at the tables created for nuBuilder and trying to decide which tables are candidates for cleaning up before a backup. I looked at the forum and wiki and I can't find a comprehensive documentation.
These following tables seem candidate to empty regular / before creating a backup can someone confirm?
zzsys_report_log
zzsys_session
zzsys_trap
zzsys_user_log
zzsys_variable

Also I find tables with a name like '_nu' these can be deleted too I guessed?

Re: Clean up tables

Posted: Tue Jan 01, 2013 2:18 pm
by alextouch
clinterman,

I don't know if all tables you posted can be truncated, but maybe this link can help you:

http://forums.nubuilder.cloud/viewtopic.php?f=6&t=7964

Alex

Re: Clean up tables

Posted: Wed Jan 02, 2013 1:10 am
by admin
clinterman,

zzsys_report_log - can be emptied
zzsys_session - can be emptied if there is noone logged in
zzsys_trap - is emptied every 2 days
zzsys_user_log - can be emptied if you don't want to keep user activity
zzsys_variable - is emptied every 2 days

Steven