Backup MySQL Vtiger Database and compress it with zip

Here is a one-liner to backup your VTiger database, give it a timestamp and zip it.

export TMPDATE=$(date +%Y%m%d-%H%M); mysqldump -p vtigercrm50 > $TMPDATE"_vtigercrm50.sql" ; zip $TMPDATE"_vtigercrm50.sql.zip" $TMPDATE"_vtigercrm50.sql" ; rm $TMPDATE"_vtigercrm50.sql"

Some explanation:

vtigercrm50 = YOUR V-TIGER DATABASE NAME

Vtiger Pop-Up in Thunderbird "Session timed-out, successfully logged in again" every 25 minutes

Vtiger

Using Thunderbird 3.1.9 and Vtiger vtigercrm-5.2.0.