upnet
Active member
Want to confirm my backup strategy is ok
Server: CentOS
Dumped the database using mysqldump
Compressed data and internal_data directories
Downloaded all to my local machine via FTP
Am I missing anything or is there a better strategy?
Server: CentOS
Dumped the database using mysqldump
Code:
/usr/bin/mysqldump --opt --user=<db username> --password --single-transaction --skip-lock-tables <database name> --default-character-set=utf8mb4 > /home/<homedirectory>/<db name>_<date>_backup.sql
Compressed data and internal_data directories
Code:
tar -zcvf forumdata_backup.tar.gz /home/<user>/public_html/data
tar -zcvf foruminternal_data_backup.tar.gz /home/<user>/public_html/internal_data
Downloaded all to my local machine via FTP
Am I missing anything or is there a better strategy?