MySQL via SSH

Posted: November 25th, 2011 ˑ Filled under: Databases, MySQL ˑ  No Comments

mysql-in

mysql-in


Connect to MySQL database via SSH
mysql -uusername -ppassword -h localhost database

Backup MySQL database via SSH
Connect to your host via SSH, login and run:
mysqldump -u username -ppassword database > {path}/backup.sql