SSH y MySQL

Elmakanico
SSH
$ ssh -p 22 user@123.123.123.123
$ mysql -u database_user -pPASSWORD
$ mysqldump database_user -pPASSWORD database_name > database_name.sql

mysqldump: [Warning] Using a password on the command line interface can be insecure.
$ mysqldump database_user -p database_name > database_name.sql
Enter password:
$ scp user@123.123.123.123:/home/user/database_name.sql .
$ scp ./README.txt user@123.123.123.123:/home/user/
$ scp ./README.txt ./README.md user@123.123.123.123:/home/user/
$ scp ./README. user@123.123.123.123:/home/user/
$ scp -r ./data user@123.123.123.123:/home/user/
$ tar -czvf Directorio.tar.gz Directorio
$ rsync -a -P remote_user@remote_host_or_ip:/opt/media/ /opt/media/

Entradas relacionadas