Database size

[fpci]

I recently did a backup and noticed the zip file was about 1 gig big.

Is there a way to run something to compact the db or is this it ?

I'm currently running Version 5.2.0j (Build 5804) of the community edition.

[rafael.q.g@hotmail.com]

Sugar data don't uses to be very big, once attachments are all stored on server file system instead on database.

Whether your database backup are really big, I can think in two options:
1. You really have a lot of data and it can't be reduced.
2. You could take a look on tracking table, it uses to be sugar biggest table cause it logs all user's actions, but its data are unnneed in a genneral way. So you would make a backup skipping this table data to check the reducing of your backup size.

[sts]

Sugar data don't uses to be very big, once attachments are all stored on server file system instead on database.

Side note: this is one of the reasons why you should always backup the sugar file system too. Another really important reason is that every change in admin section of Sugar changes the Sugar source code / configuration files and in some cases the database structure too and both parts must fit together.

[Angel]

I recently did a backup and noticed the zip file was about 1 gig big.

Is there a way to run something to compact the db or is this it ?

I'm currently running Version 5.2.0j (Build 5804) of the community edition.

The pruning job in the Sugar scheduler should be compacting it for you, assuming it is actually running. You can check it by looking at Admin > Schedulers.

Also, if you are on MS-SQL, you might want to try truncating the database's transaction log.

Lastly, is the 1 GB you mention a reference to the database or the program files? If the latter, it could be the result of a lot of attachments, either for email, notes or documents. It could also be the result of multiple uses of the Diagnostics Tools in the Admin control panel. That process makes a copy of the files one chooses to download and unless they are deleted, they remain within the directory structure of Sugar. I've seen that cause large bloats as well.