#!/bin/bash
echo "=================================================================================="
echo "Before migrating large websites run the following command to clear all cache related tables...."
echo "SELECT CONCAT('DELETE FROM ', GROUP_CONCAT(TABLE_NAME SEPARATOR ';DELETE FROM ') , ' cache;' ) AS statement FROM information_schema.TABLES WHERE TABLE_NAME LIKE 'cache_%'" | drush sqlc --extra=--skip-column-names | drush sqlc
echo "Done..."
echo "=================================================================================="

echo "=================================================================================="
echo "Certbot commands..."
certbot delete --cert-name www.herculesindustries.com
certbot certonly --webroot -w /home/hercules/public_html -d herculesindustries.com -d www.herculesindustries.com -m ssl@altagrade.com --agree-tos --non-interactive --quiet
echo "Done..."
echo "=================================================================================="

exit