This article here describes how to get Hazel to run rules in sub folders, very handy. I’m using this to move any screenshots taken on the iPhone out of the photo folder into a separate folder.
Advanced Bash-Scripting Guide. The name says it all.
Here’s how to enable a checkbox to be updated enmasse.
First create a new extvardef.php file containing the following:
Then put that file into at the following location
Of course, you’d want to check any existing files in the folder to make sure none of them already deal with that field.
From the linux command line, these commands let you backup and restore a SugarCRM database.
Update 2016-04-26: Just saw this SugarCRM KB Providing a Backup Without Sensitive Data which is really useful. Thanks Jared.
Firstly, for a proper back up of SugarCRM you’ll need two ﬁles, one containing the application ﬁles, one containing the SQL database.
First up, the backup…
Change to the folder you want to backup, then…
tar -zcvf CRM-BACKUP-FILES.tar.gz .
Edit: if you get an error ‘Permission Denied’ you may be trying to write to a folder you don’t have permission for, instead try writing to ~/CRM-BACKUP-FILES.tar.gz and it will likely work.
Edit: see also this StackOverflow article.
Backup sql (empty copy of the database):
mysqldump -u USERNAME -p -–no-data DATABASENAME > CRM-BACKUP-SQL.sql
Backup sql (with the data) :
mysqldump -u USERNAME -p DATABASENAME > CRM-BACKUP-SQL.sql
Then you can ‘tar’ the .sql file with
tar -zcvf DATABASENAME-mysql.tar.gz DATABASENAME-mysql.sql
Backup just a single table
mysqldump db_name table_name | gzip > table_name.sql.gz
If you only want the database schema, then in the SugarCRM web application you can do the following:
- Diagnostic Tool
- db schema
- Download that file
Then for the restoration…
Restore ﬁles (to current folder):
tar -zxvf CRM-BACKUP-FILES.tar.gz
mysql -u USERNAME -p DATABASENAME < CRM-BACKUP-SQL.sql
Restore just a single table
gunzip < table_name.sql.gz | mysql -u username -p db_name
These SugarCRM Knowledge Base articles may also be of use:
For when you’re trying to explain what the load average figure means (which you get from running either top or w from the linux command line) this link will help explain it easily. Easier than spending 10 minutes talking about it.