- dump database
mysqldump -u user_name -p db_name > database_dev.sql
- files_dev.zip/tar.gz all website files and folders
zip -r files_dev.zip /var/www/
- Store in directory outside of public directory
cp files_dev.zip ~/site-backup/ && cp database_dev.sql ~/site-backup/
- dump database
mysqldump -u user_name -p db_name > database_live.sql
- files_live.zip/tar.gz all website files and folders
zip -r files_live.zip /var/www/