Rsync basics

good explain at Digital Ocean https://www.digitalocean.com/community/articles/how-to-use-rsync-to-sync-local-and-remote-directories-on-a-vps rsync -a dir1/ dir2 This is necessary to mean “the contents of dir1”. sync into dir2 This, mean the whole dir1 copied into dir2…

Commandline import .sql file

mysql -u username -p database_name < file.sql mysql dump mysqldump -u username -p db_name > backup-file.sql ar…for Synology MariaDB /usr/syno/mysql/bin/mysqldump –user=$DB_USER –password=$DB_PASS Schedule a Backup of all your MySQL databases…