phpMyAdmin #

Increase upload size in PHPMYADMIN on VPS or higher cPanel server requires T1E+

Login to WHM as root.
Go to Server Configuration » Tweak Settings.
Click on PHP tab.
Update the values max upload size and max POST size to the max file size you need.

(Max: 300MiB)

Backup all Databases: #

db_backup() {
TIMESTAMP=$(date +%Y-%m-%d_%H%M)
mkdir -p /root/dbbackups/$TIMESTAMP
LIST="/root/dbbackups/${TIMESTAMP}/01_LIST"
echo -e "\tBacking up each database individually to /root/dbbackups/${TIMESTAMP}/"
echo -e "\tDB Backup list located at ${LIST}"
touch $LIST
for DB in $( mysql -e 'show databases' | grep -v "Database\|information_schema" | awk '{print $1}' ); do
mysqldump --add-drop-table $DB > /root/dbbackups/$TIMESTAMP/$DB.sql && echo $DB >> $LIST
done
cat $LIST 
}