cPanelResources

Tutorial MySQL Backups With mysqldump

Overview Discussion
cPanelResources

cPanelResources

Staff
Staff member
Apr 27, 2015
112
66
153
Houston, TX
cPanel Access Level
DataCenter Provider
cPanelResources submitted a new resource:

MySQL Backups With mysqldump - Using mysqldump to backup databases.

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 >...
Click to expand...
Read more about this resource...
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
WebHostPro Backups have an error from a MYSQL database export issue Databases 3
cPanelResources Tutorial MySQL Backups Storage Location Databases 0
cPanelResources Tutorial MySQL Backups With phpMyAdmin Databases 0
B Mysqldump failure during automatic backups (max_allowed_packet) Databases 3
J SOLVED Mysqldump failure on automatic backups Databases 17
Similar threads
Backups have an error from a MYSQL database export issue
Tutorial MySQL Backups Storage Location
Tutorial MySQL Backups With phpMyAdmin
Mysqldump failure during automatic backups (max_allowed_packet)
SOLVED Mysqldump failure on automatic backups
Top Bottom