Curso de Apache
Backup de la base de datos
#Syncronize local database with remote one
ssh user@www.my_domain.com "mysqldump -u my_remote_db_username --password=my_remote_db_password my_remote_db_name" | mysql -u my_local_db_username --password=my_local_db_password --host=localhost -C my_local_db_name
#Syncronize remote database with local one:
mysqldump -u my_local_db_username --password=my_local_db_password --host=localhost -C my_local_db_name | ssh user@www.my_domain.com "mysql -u my_remote_db_username --password=my_remote_db_password my_remote_db_name"