cPanelResources submitted a new resource:
MySQL Backups With mysqldump - Using mysqldump to backup databases.
MySQL Backups With mysqldump - Using mysqldump to backup databases.
Read more about this resource...The examples below will store the backup in/home/mysqlbackup/
. However, this should be adjusted as needed to use the partition with the most disk space available.
To backup all databases into one large compressed archive via SSH (or WHM's Terminal feature) as the root user:
Code:/usr/bin/mkdir -v /home/mysqlbackup/ ; /usr/bin/echo "Generating full MySQL backup..." ; /usr/bin/mysqldump --events --routines --triggers --all-databases | /usr/bin/gzip -9 >...