Rsync via SSH tunnel

rsync -rogpav -e ssh --delete /home/binnyva 192168.0.30:/var/Backup/home

Restoring a backup created by the dump command.

restore -if home_backup.bak

Make a incremental backup of directory ‘/home/binnyva’

dump -1aj -f home.bak /home/binnyva/

Make a full backup of directory ‘/home’

dump -0aj -f home.bak /home

Sync two folders using rsync command

rsync -rogpav --delete /home/me /backup/folder

Backup all files in /var/lib/mysql to another folder

To restore, stop mysqld if it is running

service stop mysqld

Move all database files back to /var/lib/mysql. Make sure that all the folder and files in that folder belongs to mysql

chown -R mysql.mysql /var/lib/mysql

Try starting mysql

service start mysqld

[tags]mysql,database,table,backup,data,db,restore[/tags]

Backup a folder to another local folder using the rsync tool.

rsync -av ~/Scripts/ /var/Backup/Rsync/Scripts/

a = Archive Mode
v = Verbose

[tags]backup,linux,command,rsync,folder,local,tools[/tags]

This command can be used to backup MySQL database.

mysqldump -u <User> -p <Database name> [<Table name>] > backup.sql

This command will create a file ‘backup.sql’ that will have all the data of the Database. The <Table name> is optional.

The database can be restored from such a dump using the command

mysql -u <User> <Database name> < backup.sql

Example

I backup all the task in Nexty using this command.

mysqldump -u root Apps_Nexty > nexty.sql

This will create a file called ‘nexty.sql’ - which can be restored using the command…

mysql -u root Apps_nexty < nexty.sql

[tags]mysql,backup,import,export,restore,database,command,dump,sql[/tags]

rsync -avze ssh Scripts/ binnyva@binnyva.com:backup/Scripts/

Backups the script folder to a remote location. Original Article…

[tag]linux,rsync,command,cli,backup,ssh,remote[/tag]