sugarcrm-db-dump.sh

(MySQLDUMP_DATABASE=$(sed -n "s/^.*'db_name' => '\(.*\)'.*/\1/p" config.php | head -n1) \
&& MySQLDUMP_IGNORE_TABLES=$( \
 mysql -h$(sed -n "s/^.*'db_host_name' => '\(.*\)'.*/\1/p" config.php | head -n1) \
  -u$(sed -n "s/^.*'db_user_name' => '\(.*\)'.*/\1/p" config.php | head -n1) \
  -p$(sed -n "s/^.*'db_password' => '\(.*\)'.*/\1/p" config.php | head -n1) \
  $MySQLDUMP_DATABASE \
  -e "SHOW TABLES LIKE '%_audit';" \
 | tail -n+2 \
) && \
mysqldump -h$(sed -n "s/^.*'db_host_name' => '\(.*\)'.*/\1/p" config.php | head -n1) \
-u$(sed -n "s/^.*'db_user_name' => '\(.*\)'.*/\1/p" config.php | head -n1) \
-p$(sed -n "s/^.*'db_password' => '\(.*\)'.*/\1/p" config.php | head -n1) \
 $MySQLDUMP_DATABASE \
 --ignore-table=youwecrm.$(echo $MySQLDUMP_IGNORE_TABLES|sed 's/ / --ignore-table=youwecrm./g') \
&& \
mysqldump -h$(sed -n "s/^.*'db_host_name' => '\(.*\)'.*/\1/p" config.php | head -n1) \
-u$(sed -n "s/^.*'db_user_name' => '\(.*\)'.*/\1/p" config.php | head -n1) \
-p$(sed -n "s/^.*'db_password' => '\(.*\)'.*/\1/p" config.php | head -n1) \
 $MySQLDUMP_DATABASE \
 --no-data \
 $MySQLDUMP_IGNORE_TABLES \
) | gzip -c > dbdump-no-audit-data_$(date +%Y-%m-%d_%H%M%S).sql.gz